What is the color description of the product with the name "catnip"?
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"
What are the product names of all products with the color description red?
select t1.product_name from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "red"
What are the product descriptions of all products with the color description green?
select t1.product_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "green"
Can you add into the table their product names, please?
select t1.product_name, t1.product_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "green"