Please show each industry and the corresponding number of companies in that industry.
create table companies (industry varchar, PRIMARY KEY (industry))
select industry, count(*) from companies group by industry