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