CREATE TABLE manufacturers (Headquarter VARCHAR, code VARCHAR); CREATE TABLE products (name VARCHAR, Manufacturer VARCHAR)
SELECT COUNT(DISTINCT T1.name), T2.Headquarter FROM products AS T1 JOIN manufacturers AS T2 ON T1.Manufacturer = T2.code GROUP BY T2.Headquarter
ค้นหาจำนวนผลิตภัณฑ์ต่างๆ ที่ผลิตโดยบริษัทต่างๆ ในเมืองที่มีสำนักงานใหญ่ต่างๆ
Find the number of different products that are produced by companies at different headquarter cities.