Database: products_gen_characteristics
Question: Give the name of the products that have a color description 'yellow'.
SQL:
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'