Find the name of companies whose revenue is greater than the average revenue of all companies.
CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER)
SELECT name FROM manufacturers WHERE revenue > (SELECT AVG(revenue) FROM manufacturers)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE manufacturers (name VARCHAR, revenue INTEGER) Question: Find the name of companies whose revenue is greater than the average revenue of all companies. [/INST] SELECT name FROM manufacturers WHERE revenue > (SELECT AVG(revenue) FROM manufacturers) </s>