Could you tell me how many employees have the job title PU_MAN?
select count ( * ) from employees where job_id = 'PU_MAN'
What is the salary of that employee?
select salary from employees where job_id = 'PU_MAN'
How many employees have a higher salary than that?
select count ( * ) from employees where salary > ( select salary from employees where job_id = 'PU_MAN' )
Tell me their employee numbers, first and last names, and job titles, please.
select employee_id, first_name, last_name, job_id from employees where salary > ( select max ( salary ) from employees where job_id = 'PU_MAN' )