Tell me the name of the company that has the largest number of phone models? Give the count as well.
select company_name, count(*) from phone group by company_name order by count(*) desc limit 1;
How about the smallest one?
select company_name, count(*) from phone group by company_name order by count(*) asc limit 1;