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