CREATE TABLE products (color_code VARCHAR(255), product_name VARCHAR(255)); CREATE TABLE ref_colors (color_description VARCHAR(255), color_code VARCHAR(255))
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"