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')
names of all instructors with a higher salary than any in the Biology department refers to a subquery comparison where the salary is compared to the maximum salary in the Biology department; higher salary = >; any of the instructors in the Biology department refers to SELECT MAX(salary) FROM instructor WHERE dept_name = 'Biology';