select
t1.DISTRICT_NAME as '都道府県名'
, t1.TOTAL_AMT as '総人口'
from POPULATION as t1
where t1.LVL = 2
group by 1,2
order by 2 desc