What are the typical buying prices of the products?
select typical_buying_price from products
Give this for the product with name "cumin"
select typical_buying_price from products where product_name = "basil"
How about for the name "catnip" instead?
select typical_buying_price from products where product_name = "catnip"
Give the 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"