Find the number of products with category "Spices" and typically sold above 1000.
CREATE TABLE products (product_category_code VARCHAR, typical_buying_price VARCHAR)
SELECT COUNT(*) FROM products WHERE product_category_code = "Spices" AND typical_buying_price > 1000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE products (product_category_code VARCHAR, typical_buying_price VARCHAR) Question: Find the number of products with category "Spices" and typically sold above 1000. [/INST] SELECT COUNT(*) FROM products WHERE product_category_code = "Spices" AND typical_buying_price > 1000 </s>