Evaluate the following statement.
WHEN order_total < 10000 THEN
WHEN order_total > 10000 AND order_total < 20000 THEN
WHEN order_total > 200000 AND order_total < 20000 THEN
SELECT order_id, order_total, customer_id
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?
- A: They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
- B: They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
- C: They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
- D: The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.