SELECT DISTRICT_NAME AS '都道府県名',SUM(TOTAL_AMT) AS '総人口' FROM POPULATION
WHERE LVL = 2
GROUP BY DISTRICT_NAME
order by SUM(TOTAL_AMT) desc