What is the average salary of an instructor?
select avg(salary) from instructor
What are the departments with average salary greater than that?
select dept_name from instructor group by dept_name having avg(salary) > (select avg(salary) from instructor)
Also, what are their lowest salaries?
select min(salary), dept_name from instructor group by dept_name having avg(salary) > (select avg(salary) from instructor)