Find the minimum salary for the departments whose average salary is above the average payment of all instructors.
CREATE TABLE instructor (dept_name VARCHAR, salary INTEGER)
SELECT MIN(salary), dept_name FROM instructor GROUP BY dept_name HAVING AVG(salary) > (SELECT AVG(salary) FROM instructor)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE instructor (dept_name VARCHAR, salary INTEGER) Question: Find the minimum salary for the departments whose average salary is above the average payment of all instructors. [/INST] SELECT MIN(salary), dept_name FROM instructor GROUP BY dept_name HAVING AVG(salary) > (SELECT AVG(salary) FROM instructor) </s>