SELECT count(*) FROM products WHERE product_category_code  =  "Spices" AND typical_buying_price  >  1000
How many products are in the 'Spices' category and have a typical price of over 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
How many products are in the 'Spices ' category and have a typical price of over 1000 ?