What categories of products are there?
select product_category_code from products
Show their typical buying and selling price as well.
select product_category_code, typical_buying_price, typical_selling_price from products
Show only for products with category "Herbs".
select product_category_code, typical_buying_price, typical_selling_price from products where product_category_code = "Herbs"
Of these, just give the name and product description.
select product_name, product_description from products where product_category_code = "Herbs"
Give the color descriptions as well.
select t1.product_name, t2.color_description, t1.product_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"