SELECT
    pop.PF_CODE AS 都道府県コード
    , pref.PF_NAME AS  都道府県名
    , MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE NULL END) AS 総人口2015年
    , MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE NULL END) AS 総人口2020年
    , 100 * MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE NULL END)
        / MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE NULL END) AS 人口増加率
FROM
    POPU_TRANSITION AS pop
    INNER  JOIN
        PREFECTURE AS pref
        ON pop.PF_CODE = pref.PF_CODE
WHERE
    SURVEY_YEAR IN (2015, 2020)
GROUP BY
    1, 2
HAVING  
    100 * MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE NULL END)
        / MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE NULL END) > 100
ORDER BY
    5 DESC, 1