CREATE TABLE product_characteristics (product_id VARCHAR)
CREATE TABLE ref_colors (color_description VARCHAR, color_code VARCHAR)
CREATE TABLE products (product_id VARCHAR, color_code VARCHAR)

Find the id and color description of the products with at least 2 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