Find the names of all instructors in Comp. Sci. department with salary > 80000.
CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR, salary VARCHAR)
SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.' AND salary > 80000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR, salary VARCHAR) Question: Find the names of all instructors in Comp. Sci. department with salary > 80000. [/INST] SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.' AND salary > 80000 </s>