Database: company_office
Question: Whah are the name of each industry and the number of companies in that industry?
SQL:
SELECT Industry ,  COUNT(*) FROM Companies GROUP BY Industry