WITH pf2015 AS (
    SELECT PF_CODE, TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015
),pf2020 AS (
    SELECT PF_CODE, TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020
)
SELECT pf.PF_CODE AS 都道府県コード, pf.PF_NAME AS 都道府県名, pf2015.TOTAL_AMT AS 総人口2015年, pf2020.TOTAL_AMT AS 総人口2020年, 
round(100.0 * pf2020.TOTAL_AMT / pf2015.TOTAL_AMT) AS 人口増加率
FROM PREFECTURE AS pf
JOIN pf2015 USING(PF_CODE)
JOIN pf2020 USING(PF_CODE)
WHERE pf2015.TOTAL_AMT < pf2020.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード ASC