SELECT
    DISTRICT_CODE AS 地区コード
    , DISTRICT_NAME AS 地区名
    , SUM(TOTAL_AMT) AS 総人口
FROM
    POPULATION
GROUP BY
    1, 2
ORDER BY
    総人口 DESC
    , 地区コード DESC
;