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