EasyOutput prediction
Multiple WHEN branches
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;← → arrow keys to navigate
Sign in to save your progress.