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