SELECT DISTINCT
    a.PF_CODE AS 都道府県コード,
    PF_NAME AS 都道府県名,
    (SELECT TOTAL_AMT FROM POPU_TRANSITION AS b WHERE SURVEY_YEAR = 2015 AND b.PF_CODE = a.PF_CODE) AS 総人口2015年,
    (SELECT TOTAL_AMT FROM POPU_TRANSITION AS c WHERE SURVEY_YEAR = 2020 AND c.PF_CODE = a.PF_CODE) AS 総人口2020年,
    ROUND(100*CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION AS c WHERE SURVEY_YEAR = 2020 AND c.PF_CODE = a.PF_CODE) AS REAL)/CAST((SELECT TOTAL_AMT FROM POPU_TRANSITION AS b WHERE SURVEY_YEAR = 2015 AND b.PF_CODE = a.PF_CODE) AS REAL), 0) AS 人口増加率
FROM 
    POPU_TRANSITION AS a INNER JOIN PREFECTURE AS b ON (a.PF_CODE = b.PF_CODE)
ORDER BY
    人口増加率 DESC,
    都道府県コード