CREATE TABLE products (product_name VARCHAR, product_id VARCHAR)
CREATE TABLE complaints (product_id VARCHAR)

List the name of all products along with the number of complaints that they have received.
SELECT t1.product_name, COUNT(*) FROM products AS t1 JOIN complaints AS t2 ON t1.product_id = t2.product_id GROUP BY t1.product_name
SELECT "t1"."product_name", COUNT(*) FROM "products" AS "t1" JOIN "complaints" AS "t2" ON "t1"."product_id" = "t2"."product_id" GROUP BY "t1"."product_name"