SELECT 
    FY15.PF_CODE AS "都道府県コード",
    KEN.PF_NAME AS "都道府県名", 
    FY15.TOTAL_AMT AS "総人口2015年" ,
    FY20.TOTAL_AMT AS "総人口2020年", 
    ROUND(CAST(FY20.TOTAL_AMT AS FLOAT) / CAST(FY15.TOTAL_AMT AS FLOAT) *100,0) AS "人口増加率"
FROM ( 
    SELECT 
        SURVEY_YEAR,
        PF_CODE,
        TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2015 
) AS FY15 
LEFT JOIN (
    SELECT
        SURVEY_YEAR,
        PF_CODE,
        TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020 
) AS FY20 
ON FY15.PF_CODE = FY20.PF_CODE
LEFT JOIN PREFECTURE KEN
ON FY15.PF_CODE = KEN.PF_CODE
WHERE "人口増加率" >= 100
ORDER BY "人口増加率" DESC, FY15.PF_CODE
;