What is the average salary of instructors in the Physics department?
select avg(salary) from instructor where dept_name = 'Physics'
What are the names of the instructors who earn more than that?
select name from instructor where salary < (select avg(salary) from instructor where dept_name = 'Physics')
Also, what are their salaries?
select name, salary from instructor where salary < (select avg(salary) from instructor where dept_name = 'Physics')