with lvl2 as(
    select DISTRICT_NAME as dn,
            TOTAL_AMT as ta
    from POPULATION
    where LVL = 2
)

select dn as "都道府県名",
        sum(ta) as "総人口"
from lvl2
group by dn
order by 2 desc;