What are the product descriptions?
select product_description from products
What are the names of products with product description "eius"
select product_name from products where product_description = "eius"
How about those with color description "yellow"
select t1.product_name from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = 'yellow'