Show names for all employees with salary more than the average.
CREATE TABLE Employee (name VARCHAR, salary INTEGER)
SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Employee (name VARCHAR, salary INTEGER) Question: Show names for all employees with salary more than the average. [/INST] SELECT name FROM Employee WHERE salary > (SELECT AVG(salary) FROM Employee) </s>