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
;