SELECT DISTRICT_NAME AS 都道府県名
      ,TOTAL_AMT     AS 総人口
  FROM POPULATION
 GROUP BY DISTRICT_NAME
 ORDER BY TOTAL_AMT DESC