How many different company industries are there?
select count(distinct industry) from companies
What are they?
select distinct industry from companies
Which one has the least number of companies?
select industry from companies group by industry order by count(*) asc limit 1
How about the most?
select industry from companies group by industry order by count(*) desc limit 1