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
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
What are all the different product names , and how many complains has each received ?