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 <table_name> : Products col : product_id | parent_product_id | product_category_code | date_product_first_available | date_product_discontinued | product_name | product_description | product_price row 1 : 117 | 4 | Food | 1988-09-29 17:54:50 | 1987-12-20 13:46:16 | Chocolate | Handmade chocolate | 2.88 row 2 : 118 | 3 | Book | 1974-06-25 12:26:47 | 1991-08-20 05:22:31 | The Great Gatsby | American novel | 35.0 row 3 : 119 | 8 | Hardware | 1994-12-18 15:13:19 | 1997-07-02 18:26:16 | Keyboard | Designed for games | 109.99 row 4 : 120 | 9 | Hardware | 1998-06-20 15:04:11 | 1980-06-26 10:40:19 | Mouse | Blue tooth mouse | 23.35 <table_name> : Complaints col : complaint_id | product_id | customer_id | complaint_outcome_code | complaint_status_code | complaint_type_code | date_complaint_raised | date_complaint_closed | staff_id row 1 : 1 | 117 | 120 | OK | Closed | Product Failure | 2002-07-18 10:59:35 | 1976-04-19 11:03:06 | 114 row 2 : 2 | 118 | 113 | OK | New | Product Unusable | 1973-02-10 22:55:56 | 2013-09-14 02:59:10 | 120 row 3 : 3 | 119 | 114 | OK | New | Product Unusable | 2006-10-29 07:08:46 | 1995-09-11 14:48:46 | 115 row 4 : 4 | 120 | 114 | OK | Closed | Product Unusable | 1977-08-06 00:31:19 | 1970-10-14 00:57:25 | 114 row 5 : 5 | 117 | 118 | OK | Open | Product Failure | 2007-10-14 21:50:43 | 2000-08-17 17:02:48 | 116 row 6 : 6 | 118 | 114 | OK | Open | Product Unusable | 1987-07-11 14:40:30 | 1975-10-11 05:54:30 | 114 row 7 : 7 | 117 | 117 | OK | New | Product Unusable | 2002-07-18 10:59:35 | 1976-04-19 11:03:06 | 118 row 8 : 8 | 117 | 114 | OK | New | Product Unusable | 1973-02-10 22:55:56 | 2013-09-14 02:59:10 | 117 row 9 : 9 | 117 | 116 | OK | New | Product Unusable | 2006-10-29 07:08:46 | 1995-09-11 14:48:46 | 120 row 10 : 10 | 118 | 115 | OK | New | Product Unusable | 1977-08-06 00:31:19 | 1970-10-14 00:57:25 | 114 row 11 : 11 | 118 | 116 | OK | Open | Product Unusable | 2007-10-14 21:50:43 | 2000-08-17 17:02:48 | 115 row 12 : 12 | 117 | 116 | OK | Open | Product Unusable | 1987-07-11 14:40:30 | 1975-10-11 05:54:30 | 114
col : product_name | count(*) row 1 : Chocolate | 6 row 2 : Keyboard | 1 row 3 : Mouse | 1 row 4 : The Great Gatsby | 4