Database: products_gen_characteristics
Question: Return the names and typical buying and selling prices for products that have 'yellow' as their color description.
SQL:
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"