EasyOutput prediction
Basic CASE WHEN
Given this table (employees):
| id | name | salary |
|---|---|---|
| 1 | Alice | 90000 |
| 2 | Bob | 55000 |
What does this query return?
SELECT name,
CASE WHEN salary >= 70000 THEN 'Senior' ELSE 'Junior' END AS level
FROM employees;← → arrow keys to navigate
Sign in to save your progress.