Can you list the color code that has a color description of 'white'?
select color_code from ref_colors where color_description = 'white'
Can you list all product ids and their associated product category codes that have a color code value of 2?
select product_id,product_category_code from products where color_code = '2'
Sure, can you add to the table the unit of measure values for the product category codes of Spices and Herbs?
select unit_of_measure from ref_product_categories where product_category_code = 'Herbs' or product_category_code = 'Spices'
Please delete that information and only show the product name for the product with a product id of 2.
select product_name from products where product_id = '2'