What are the product descriptions?
select product_description from products
For the one with the name "chervil"?
select product_description from products where product_name = "chervil"
Give the color description instead.
select t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "chervil"
Show the color code as well.
select t1.color_code, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "chervil"