select 
DISTRICT_CODE as 地区コード, 
DISTRICT_NAME as 地区名,
sum(TOTAL_AMT) as 総人口
from
POPULATION
group by DISTRICT_CODE
order by 総人口, 地区コード desc;