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
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 ( * ) > = value
What are the product ids and color descriptions for products with two or more characteristics ?