SELECT employee_id FROM employees WHERE salary  >  (SELECT AVG(salary) FROM employees)
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 )
Find the employee id for all employees who earn more than the average salary .