Database: customer_complaints
Question: List the name of all products along with the number of complaints that they have received.
SQL:
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