For each headquarter, what are the headquarter and how many companies are centered there?
SELECT headquarters ,  count(*) FROM company GROUP BY headquarters
For each headquarter refers to GROUP BY headquarters; how many companies are centered there refers to COUNT(*);