CREATE TABLE products (Manufacturer VARCHAR)
CREATE TABLE manufacturers (name VARCHAR, code VARCHAR)

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"