Return the name, location and district of all shops in descending order of number of products.
CREATE TABLE shop (name VARCHAR, LOCATION VARCHAR, district VARCHAR, number_products VARCHAR)
SELECT name, LOCATION, district FROM shop ORDER BY number_products DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE shop (name VARCHAR, LOCATION VARCHAR, district VARCHAR, number_products VARCHAR) Question: Return the name, location and district of all shops in descending order of number of products. [/INST] SELECT name, LOCATION, district FROM shop ORDER BY number_products DESC </s>