Find the names of all instructors whose salary is greater than the salary of all instructors in the Biology department.
CREATE TABLE instructor (name VARCHAR, salary INTEGER, dept_name VARCHAR)
SELECT name FROM instructor WHERE salary > (SELECT MAX(salary) FROM instructor WHERE dept_name = 'Biology')
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE instructor (name VARCHAR, salary INTEGER, dept_name VARCHAR) Question: Find the names of all instructors whose salary is greater than the salary of all instructors in the Biology department. [/INST] SELECT name FROM instructor WHERE salary > (SELECT MAX(salary) FROM instructor WHERE dept_name = 'Biology') </s>