select DISTRICT_NAME as "都道府県名", total_amt as "総人口" from population where lvl='2' group by 1 order by 2 desc;