Select DISTRICT_NAME as '都道府県名', sum(TOTAL_AMT) as '総人口' from POPULATION where LVL=2 GROUP BY DISTRICT_CODE order by TOTAL_AMT desc;