What is the product description for this product?
select product_description from products where product_name = "chervil"
Also, what is the color code?
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"
Great, what is the typical product price for this product?
select typical_buying_price from products where product_name = "chervil"
No worries, are there any other product details that I should know about?
select other_product_details from products where product_name = "chervil"