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 avg(salary)  >  (SELECT avg(salary) FROM instructor)
[{'min(salary)': 79070.08, 'dept_name': 'Astronomy'}, {'min(salary)': 80797.83, 'dept_name': 'Comp. Sci.'}, {'min(salary)': 79866.95, 'dept_name': 'Cybernetics'}, {'min(salary)': 105311.38, 'dept_name': 'Finance'}, {'min(salary)': 99382.59, 'dept_name': 'Geology'}, {'min(salary)': 43770.36, 'dept_name': 'Marketing'}, {'min(salary)': 51647.57, 'dept_name': 'Mech. Eng.'}, {'min(salary)': 108011.81, 'dept_name': 'Physics'}, {'min(salary)': 87549.8, 'dept_name': 'Pol. Sci.'}]