Which products have category "Herbs"
select * from products where product_category_code = "Herbs"
How about category "Spices" instead
select * from products where product_category_code = "Spices"
How many are these?
select count(*) from products where product_category_code = "Spices"
Restrict the count of those to the ones typically bought below 100.
select count(*) from products where product_category_code = "Spices" and typical_buying_price < 100
Restrict to the ones typically sold above 1000 instead.
select count(*) from products where product_category_code = "Spices" and typical_selling_price > 1000