Which district has both stores with less than 3000 products and stores with more than 10000 products?
CREATE TABLE shop (district VARCHAR, Number_products INTEGER)
SELECT district FROM shop WHERE Number_products < 3000 INTERSECT SELECT district FROM shop WHERE Number_products > 10000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE shop (district VARCHAR, Number_products INTEGER) Question: Which district has both stores with less than 3000 products and stores with more than 10000 products? [/INST] SELECT district FROM shop WHERE Number_products < 3000 INTERSECT SELECT district FROM shop WHERE Number_products > 10000 </s>