SELECT
DISTRICT_CODE AS "地区コード",
DISTRICT_NAME AS "地区名",
TOTAL_AMT AS "総人口"
FROM POPULATION
GROUP BY DISTRICT_CODE
ORDER BY TOTAL_AMT DESC, DISTRICT_CODE ASC;