Show each company id and its industry.
select id, industry from companies
Show how many companies are in each industry.
select industry, count(*) from companies group by industry
Sort industries by the number of companies in a descending order!
select industry, count(*) from companies group by industry order by count(*) desc
Actually, can you just show the industries!
select industry from companies group by industry order by count(*) desc