Table schema:
CREATE TABLE Employee (name VARCHAR, salary INTEGER)

Question: Show names for all employees with salary more than the average.
SQL: SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee)