SELECT employee_id ,  first_name ,  last_name ,  job_id FROM employees WHERE salary  >  ( SELECT max(salary) FROM employees WHERE job_id  =  'PU_MAN' )
What are the employee ids, full names, and job ids for employees who make more than the highest earning employee with title PU_MAN?
SELECT employee_id , first_name , last_name , job_id FROM employees WHERE salary > ( SELECT max ( salary ) FROM employees WHERE job_id = 'PU_MAN ' )
select employee_id , first_name , last_name , job_id from employees where salary > ( select max ( salary ) from employees where job_id = value )
What are the employee ids , full names , and job ids for employees who make more than the highest earning employee with title PU_MAN ?