select 
    DISTRICT_NAME as '都道府県名',
    TOTAL_AMT as '総人口'
from 
    POPULATION
where
    lvl = 2
group by 
    DISTRICT_NAME
order by 
    総人口 DESC