what is the color code of product name "chervil"?
select t1.color_code from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "chervil"
what is the color description of it?
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"
What is the product id of it?
select t1.product_id from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "chervil"