Find the number of products for each manufacturer, showing the name of each company.
SELECT count(*) ,  T2.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer  =  T2.code GROUP BY T2.name
SELECT count(*) ,  T2.name FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer  =  T2.code GROUP BY T2.name
[{'count(*)': 3, 'Name': 'Creative Labs'}, {'count(*)': 1, 'Name': 'Fujitsu'}, {'count(*)': 3, 'Name': 'Hewlett-Packard'}, {'count(*)': 1, 'Name': 'Iomega'}, {'count(*)': 1, 'Name': 'Sony'}, {'count(*)': 2, 'Name': 'Winchester'}]