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