what is the color code of basil?
select color_code from products where product_name = 'basil'
what is the color with least products?
select t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code group by t2.color_description order by count ( * ) asc limit 1
what is the name of the product with color code 4?
select product_name from products where color_code = 4
What is the typical selling price of product paper?
select typical_selling_price from products where product_name = 'peper'