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