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