What is the highest salary of instructors in the Biology department?
select max(salary) from instructor where dept_name = 'Biology'
What are the names of instructors who earn more than this?
select name from instructor where salary > (select max(salary) from instructor where dept_name = 'Biology')