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)