What is the color of the product named "ginger"?
select t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "ginger"
Show its unit of measurement instead.
select t2.unit_of_measure from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code where t1.product_name = "ginger"
Give the product category code as well.
select t2.unit_of_measure, t2.product_category_code from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code where t1.product_name = "ginger"
Do this for the product named "chervil" instead.
select t2.unit_of_measure, t2.product_category_code from products as t1 join ref_product_categories as t2 on t1.product_category_code = t2.product_category_code where t1.product_name = "chervil"