Show names for all employees with salary more than the average.
CREATE TABLE Employee (name VARCHAR, salary INTEGER)
SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee)
### Context: CREATE TABLE Employee (name VARCHAR, salary INTEGER) ### Question: Show names for all employees with salary more than the average. ### Answer: SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee)