Database: products_gen_characteristics
Question: What is the color code and description of the product named "chervil"?
SQL:
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"