CREATE TABLE instructor (dept_name VARCHAR, salary INT)

Find the minimum salary for the departments whose average salary is above the average payment of all instructors.
SELECT MIN(salary), dept_name FROM instructor GROUP BY dept_name HAVING AVG(salary) > (SELECT AVG(salary) FROM instructor)
SELECT MIN("salary"), "dept_name" FROM "instructor" GROUP BY "dept_name" HAVING (SELECT AVG("salary") FROM "instructor") < AVG("salary")