WITH t_15 AS (
SELECT
    PF_CODE
    ,TOTAL_AMT AS z_2015
FROM
    POPU_TRANSITION    
WHERE
    SURVEY_YEAR = 2015
),t_20 AS (
SELECT
    PF_CODE
    ,TOTAL_AMT AS z_2020
FROM
    POPU_TRANSITION    
WHERE
    SURVEY_YEAR = 2020
)

SELECT
    t_15.PF_CODE AS都道府県コード
    ,PREFECTURE.PF_NAME AS 都道府県名
    ,t_15.z_2015 AS 総人口2015年
    ,t_20.z_2020 AS 総人口2020年
    ,ROUND(t_20.z_2020 * 1.0 /t_15.z_2015 * 100, 0) AS 人口増加率
FROM
    t_15
INNER JOIN t_20 ON t_15.PF_CODE = t_20.PF_CODE
INNER JOIN PREFECTURE ON t_15.PF_CODE = PREFECTURE.PF_CODE
WHERE t_20.z_2020 > t_15.z_2015

ORDER BY
    人口増加率 DESC , t_15.PF_CODE ASC