SELECT DISTRICT_NAME AS"都道府県名" ,SUM(TOTAL_AMT) AS"総人口"
FROM POPULATION
WHERE LVL = 2
GROUP BY DISTRICT_NAME
ORDER BY 2 DESC;