WITH total AS (
    SELECT
        p.PF_CODE,p.PF_NAME,
        p_t.SURVEY_YEAR,p_t.TOTAL_AMT
    FROM
        POPU_TRANSITION p_t
        INNER JOIN PREFECTURE p ON p_t.PF_CODE = p.PF_CODE
),
total_2015 AS (
    SELECT
        PF_CODE,
        PF_NAME,
        TOTAL_AMT AS total_amt_2015
    FROM
        total
    WHERE
        SURVEY_YEAR = 2015
),
total_2020 AS (
    SELECT
        PF_CODE,
        PF_NAME,
        TOTAL_AMT AS total_amt_2020
    FROM
        total
    WHERE
        SURVEY_YEAR = 2020
)
select
    a.PF_CODE as 都道府県コード
    ,a.PF_NAME as 都道府県名
    ,a.total_amt_2015 as 総人口2015年
    ,b.total_amt_2020 as 総人口2020年
    ,ROUND(cast(b.total_amt_2020 as REAL)/cast(a.total_amt_2015 as REAL)*100,0) as 人口増加率
from
    total_2015 a
    left join
    total_2020 b on a.PF_CODE = b.PF_CODE
where
    a.total_amt_2015 < b.total_amt_2020
order by 
    人口増加率 DESC
    ,都道府県コード