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