CREATE TABLE employees (employee_id VARCHAR, salary INT)

Find the employee id for all employees who earn more than the average salary.
SELECT employee_id FROM employees WHERE salary > (SELECT AVG(salary) FROM employees)
SELECT "employee_id" FROM "employees" WHERE "salary" > (SELECT AVG("salary") FROM "employees")