What is the highest salary for someone with the title PU_MAN?
select max(salary) from employees where job_id = 'PU_MAN'
Which employees make more than that?
select * from employees where salary > ( select max(salary) from employees where job_id = 'PU_MAN' )
What are their employee ids, full names, and job ids?
select employee_id, first_name, last_name, job_id from employees where salary > ( select max(salary) from employees where job_id = 'PU_MAN' )