1. select city, count(*) as cnt from table group by city

city cnt
合肥 3
上海 1
武汉 2
杭州 1

2. select a.city, a.company from table a
left join (select city, count(*) as cnt from table group by city) b
on a.city = b.city
order by b.cnt desc, a.company