What is the cheapest phone?
select * from phone order by price asc limit 1
Which carrier has this?
select carrier from phone order by price asc limit 1
Which one has the most phones instead?
select carrier from phone group by carrier order by count(*) desc limit 1