What are the product ids and color descriptions for products with two or more characteristics?
SELECT t1.product_id ,  t2.color_description FROM products AS t1 JOIN ref_colors AS t2 ON t1.color_code  =  t2.color_code JOIN product_characteristics AS t3 ON t1.product_id  =  t3.product_id GROUP BY t1.product_id HAVING count(*)  >=  2
SELECT t1.product_id ,  t2.color_description FROM products AS t1 JOIN ref_colors AS t2 ON t1.color_code  =  t2.color_code JOIN product_characteristics AS t3 ON t1.product_id  =  t3.product_id GROUP BY t1.product_id HAVING count(*)  >=  2
[{'product_id': 6, 'color_description': 'blue'}, {'product_id': 7, 'color_description': 'red'}, {'product_id': 11, 'color_description': 'black'}, {'product_id': 12, 'color_description': 'blue'}]