what are the names of the products with category "Herbs"
select t1.product_name from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"
yes
select t1.product_name, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"
list down all the product ids
select product_id from products