What is the typical selling price of the product named "catnip"?
select typical_selling_price from products where product_name = "catnip"
Show its color description instead.
select t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t1.product_name = "catnip"
Give 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 = "cumin"