Show names for all employees with salary more than the average.
SELECT name FROM Employee WHERE salary  >  (SELECT avg(salary) FROM Employee)
employees with salary more than the average refers to salary > AVG(salary);