What are all the different product names, and how many complains has each 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
[{'product_name': 'Chocolate', 'count(*)': 6}, {'product_name': 'Keyboard', 'count(*)': 1}, {'product_name': 'Mouse', 'count(*)': 1}, {'product_name': 'The Great Gatsby', 'count(*)': 4}]