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"
Return the names and typical buying and selling prices for products that have 'yellow' as their color description.
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 as t1 join ref_colors as t2 on t1 . color_code = t2 . color_code where t2 . color_description = value
Return the names and typical buying and selling prices for products that have 'yellow ' as their color description .