select DISTRICT_NAME as 都道府県名, SUM(TOTAL_AMT) as 総人口 from POPULATION group by DISTRICT_NAME having LVL = 2 order by 総人口 desc;