Show the name of the product with product id 1?
select product_name from products where product_id = '1'
show the number of products with category Spices?
select count ( * ) from products where product_category_code = 'Spices'
Show 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