select
    DISTRICT_CODE,
    DISTRICT_NAME,
    sum(total_amt) TOTAL_AMT
from
    population
group by
    district_code, district_name
order by
    total_amt desc, district_code desc
;