What are the color descriptions?
select color_description from ref_colors
Show the corresponding product names.
select t1.product_name, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code
Filter for only the ones with color "black"
select t1.product_name, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "black"
Now for color "white" instead.
select t1.product_name, t2.color_description from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "white"
Show only the product names instead.
select t1.product_name from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "white"