select 
  district_code as 地区コード,
  district_name as 地区名,
  sum(total_amt) as 総人口
from population
group by district_code
order by 総人口 desc, 地区コード desc