CASE Expressions1 / 4
EASY·Output prediction
Given this table (orders): | id | amount | |----|--------| | 1 | 50 | | 2 | 200 | | 3 | 600 | What does this query return?
SELECT id,
CASE
WHEN amount < 100 THEN 'Small'
WHEN amount < 500 THEN 'Medium'
ELSE 'Large'
END AS size
FROM orders;Sign in to save your progress.