CASE converts conditions into labels or calculated categories.
CASE converts conditions into labels or calculated categories. Read the query line by line and identify the input table, the transformation, and the shape of the result before running it.
SELECT order_id, amount, CASE WHEN amount >= 2000 THEN 'Large' ELSE 'Standard' END AS order_size FROM orders ORDER BY order_id;
Before running the example, predict the output columns and whether the query returns one row, many rows, or possibly no rows.
In your own words, explain the main SQL feature in today’s lesson and why it answers the question.
Recall prompt: Use CASE WHEN amount >= 2000 THEN 'Large' ELSE 'Standard' END. Close this page section mentally and explain the query from memory before proceeding.
Label each order Large when amount is at least 2000, otherwise Standard.
Use CASE WHEN amount >= 2000 THEN 'Large' ELSE 'Standard' END.