select DISTRICT_CODE as 地区コード, DISTRICT_NAME as 地区名, SUM(TOTAL_AMT) as 総人口
from POPULATION
GROUP BY DISTRICT_CODE, DISTRICT_NAME
order by SUM(TOTAL_AMT) DESC,DISTRICT_CODE DESC