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年
    , ROUND(100 * MAX(CASE WHEN SURVEY_YEAR = 2022 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  
    MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE NULL END) < MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE NULL END)
ORDER BY
    5 DESC, 1