select
    t.DISTRICT_NAME as 都道府県名
    ,t.TOTAL_AMT as 総人口
from population t
where 1 = 1
    and t.LVL = 2
order by t.total_amt DESC