with y2015 as(
    SELECT
        PF_CODE
        ,SURVEY_YEAR
        ,sum(TOTAL_AMT) OVER (PARTITION BY PF_CODE,SURVEY_YEAR) as total
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR IN (2015)
),
y2020 as(
    SELECT
        PF_CODE
        ,SURVEY_YEAR
        ,sum(TOTAL_AMT) OVER (PARTITION BY PF_CODE,SURVEY_YEAR) as total
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR IN (2020)
)

SELECT
    t1.PF_CODE as 都道府県コード
    ,t3.PF_NAME as 都道府県名
    ,t1.total as 総人口2015年
    ,t2.total as 総人口2020年
    ,round((cast(t2.total as real)/cast(t1.total as real))*100) as 人口増加率
FROM
    y2015 t1
inner join y2020 t2 on t1.PF_CODE = t2.PF_CODE
inner join PREFECTURE t3 on t1.PF_CODE = t3.PF_CODE

ORDER BY 
人口増加率 desc
,都道府県コード desc