select
    pf_code as `都道府県コード`,
    pf_name as `都道府県名`,
    amt_2015 as `総人口2015年`,
    amt_2020 as `総人口2020年`,
    round(amt_2020 / cast(amt_2015 as real) * 100.0) as `人口増加率`
from
    (
        select
            T.PF_CODE as pf_code,
            P.PF_NAME as pf_name,
            MAX(IIF(SURVEY_YEAR = 2015, TOTAL_AMT, NULL)) as amt_2015,
            MAX(IIF(SURVEY_YEAR = 2020, TOTAL_AMT, NULL)) as amt_2020
        from
            POPU_TRANSITION as T
            left join PREFECTURE as P on T.PF_CODE = P.PF_CODE
        where
            SURVEY_YEAR in (2015, 2020)
        group by
            T.pf_code
    )
where
    amt_2020 > amt_2015
order by
    `人口増加率` desc,
    `都道府県コード` asc;