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