select
    PREFECTURE.PF_CODE as "都道府県コード",
    PREFECTURE.PF_NAME as "都道府県名",
    POPU15.TOTAL_AMT as "総人口2015年",
    POPU20.TOTAL_AMT as "総人口2020年",
    round(
        100 * cast(POPU20.TOTAL_AMT as REAL) / POPU15.TOTAL_AMT,
        0
    ) as "人口増加率"
from
    (
        select
            PF_CODE,
            TOTAL_AMT
        from
            POPU_TRANSITION
        where
            SURVEY_YEAR == 2015
    ) as POPU15,
    (
        select
            PF_CODE,
            TOTAL_AMT
        from
            POPU_TRANSITION
        where
            SURVEY_YEAR == 2020
    ) as POPU20,
    PREFECTURE
where
    POPU15.PF_CODE == PREFECTURE.PF_CODE
    and POPU20.PF_CODE == PREFECTURE.PF_CODE
    and POPU15.TOTAL_AMT < POPU20.TOTAL_AMT
order by
    "人口増加率" desc,
    "都道府県コード"