SELECT 
TOTAL_2015.PF_CODE AS 都道府県コード
,PF.PF_NAME AS 都道府県名
,TOTAL_2015.TOTAL_AMT AS 総人口2015年
,TOTAL_2020.TOTAL_AMT AS 総人口2020年
,ROUND(CAST(TOTAL_2020.TOTAL_AMT AS REAL) / CAST(TOTAL_2015.TOTAL_AMT AS REAL) * 100) AS 人口増加率
FROM(
    SELECT 
    PF_CODE
    ,TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015
) TOTAL_2015
INNER JOIN(
    SELECT 
    PF_CODE
    ,TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020
) TOTAL_2020
ON TOTAL_2015.PF_CODE = TOTAL_2020.PF_CODE
LEFT JOIN PREFECTURE PF
ON TOTAL_2015.PF_CODE = PF.PF_CODE
WHERE TOTAL_2015.TOTAL_AMT < TOTAL_2020.TOTAL_AMT
ORDER BY
人口増加率 DESC, TOTAL_2015.PF_CODE ASC