CREATE TABLE ref_colors (color_code VARCHAR2, color_description VARCHAR2)
CREATE TABLE products (product_name VARCHAR2, typical_buying_price VARCHAR2, typical_selling_price VARCHAR2, color_code VARCHAR2)

What are the name and typical buying and selling prices of the products that have color described as 'yellow'?
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"
SELECT "t1"."product_name", "t1"."typical_buying_price", "t1"."typical_selling_price" FROM "products" "t1" JOIN "ref_colors" "t2" ON "t1"."color_code" = "t2"."color_code" AND "t2"."color_description" = "yellow"