select DISTRICT_NAME AS '都道府県名' ,SUM(TOTAL_AMT) AS '総人口' from POPULATION where LVL=2 order by TOTAL_AMT;