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 
INNER JOIN (
    SELECT
        SURVEY_YEAR,
        PF_CODE,
        TOTAL_AMT
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR = 2020 
) AS FY20 
ON FY15.PF_CODE = FY20.PF_CODE
INNER JOIN PREFECTURE KEN
ON FY15.PF_CODE = KEN.PF_CODE
WHERE (FY20.TOTAL_AMT - FY15.TOTAL_AMT) > 0
ORDER BY "人口増加率" DESC, "都道府県コード"
;