what is the name of the instructor who is in Statistics department and earns the lowest salary?
CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR, salary VARCHAR)
SELECT TOP 1 name FROM instructor WHERE dept_name = 'Statistics' ORDER BY salary
<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: what is the name of the instructor who is in Statistics department and earns the lowest salary? [/INST] SELECT TOP 1 name FROM instructor WHERE dept_name = 'Statistics' ORDER BY salary </s>