SCHEMA:
CREATE TABLE Employee (name VARCHAR, salary INTEGER)
USER:
Show names for all employees with salary more than the average.

QUERY:
SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee)