SELECT name FROM instructor WHERE salary  >  (SELECT max(salary) FROM instructor WHERE dept_name  =  'Biology')
What are the names of all instructors with a higher salary than any of the instructors in the Biology department?
SELECT name FROM instructor WHERE salary > ( SELECT max ( salary ) FROM instructor WHERE dept_name = 'Biology ' )
select name from instructor where salary > ( select max ( salary ) from instructor where dept_name = value )
What are the names of all instructors with a higher salary than any of the instructors in the Biology department ?