What is the average salary across all employees?
select avg(salary) from employees
Which employees make more than that?
select * from employees where salary > (select avg(salary) from employees)
What are their ids?
select employee_id from employees where salary > (select avg(salary) from employees)