What is the lowest salary of instructors in the Biology department?
select min(salary) from instructor where dept_name = 'Biology'
What are the ids of instructors who earn more than that?
select id from instructor where salary > (select min(salary) from instructor where dept_name = 'Biology')
What are their names?
select name from instructor where salary > (select min(salary) from instructor where dept_name = 'Biology')