select
    --floor(district_code / 100) as dist_cd,
    district_name as "都道府県名",
    sum(total_amt) as "総人口"

from
  population
  
where
  lvl <> 1

group by
  floor(district_code / 1000)

order by
  total_amt desc