select
 DISTRICT_NAME AS '都道府県名'
,SUM(TOTAL_AMT) AS '総人口'

from POPULATION

where LVL=2

group by
 DISTRICT_NAME
,LVL

order by '総人口' desc;