Return the first names and last names of employees who earn more than 30000 in salary.
CREATE TABLE employee (fname VARCHAR, lname VARCHAR, salary INTEGER)
SELECT fname, lname FROM employee WHERE salary > 30000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employee (fname VARCHAR, lname VARCHAR, salary INTEGER) Question: Return the first names and last names of employees who earn more than 30000 in salary. [/INST] SELECT fname, lname FROM employee WHERE salary > 30000 </s>