SELECT count(*) FROM products WHERE product_category_code  =  "Spices" AND typical_buying_price  >  1000
Find the number of products with category "Spices" and typically sold above 1000.
SELECT count ( * ) FROM products WHERE product_category_code = `` Spices '' AND typical_buying_price > 1000
select count ( * ) from products where product_category_code = value and typical_buying_price > value
Find the number of products with category `` Spices '' and typically sold above 1000 .