What is the lowest salary in departments with average salary greater than the overall average.
SELECT min(salary) ,  dept_name FROM instructor GROUP BY dept_name HAVING avg(salary)  >  (SELECT avg(salary) FROM instructor)
lowest salary refers to MIN(salary); departments with average salary greater than the overall average refers to departments WHERE AVG(salary) > (SELECT AVG(salary) FROM instructor);