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
;