What are the names of the products with the category "Herbs" please?
select t1.product_name from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"
What are their color descriptions?
select t1.product_name, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"
What are their product descriptions?
select t1.product_name, t2.color_description, t1.product_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"
What are their typical selling prices?
select t1.typical_selling_price from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"
What is the average typical buying price?
select avg ( typical_buying_price ) from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where product_category_code = "Herbs"