EasyOutput prediction
Scalar subquery in WHERE
Given this table (employees):
| id | name | salary |
|---|---|---|
| 1 | Alice | 90000 |
| 2 | Bob | 75000 |
| 3 | Carol | 82000 |
What does this query return?
SELECT name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);
← → arrow keys to navigate
Sign in to save your progress.