what are the color descriptions for the products? | Do you want both the names and the color descriptions? | 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"
product names and color descriptions requires joining two tables, products and Ref_colors, based on a common attribute, color_code; filtering results based on product category 'Herbs' involves WHERE clause with product_category_code = 'Herbs';