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