Find the names of stores whose number products is more than the average number of products.
CREATE TABLE shop (name VARCHAR, number_products INTEGER)
SELECT name FROM shop WHERE number_products > (SELECT AVG(number_products) FROM shop)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE shop (name VARCHAR, number_products INTEGER) Question: Find the names of stores whose number products is more than the average number of products. [/INST] SELECT name FROM shop WHERE number_products > (SELECT AVG(number_products) FROM shop) </s>