What are the name and typical buying and selling prices of the products that have color described as "yellow"?
create table ref_colors (color_code varchar, color_description varchar, PRIMARY KEY (color_code)); create table products (product_name varchar, typical_buying_price varchar, typical_selling_price varchar, color_code varchar, PRIMARY KEY (product_name))
select t1.product_name, t1.typical_buying_price, t1.typical_selling_price from products as t1 join ref_colors as t2 on t1.color_code = t2.color_code where t2.color_description = "yellow"