select DISTRICT_NAME "都道府県名", sum(TOTAL_AMT) "総人口" from POPULATION where lvl = 2 group by 1 order by 2 desc