SELECT 
    p.PF_CODE as '都道府県コード'
    ,p.PF_NAME as '都道府県名'
    ,old.TOTAL_AMT as '総人口2015年'
    ,new.TOTAL_AMT as '総人口2020年'
    ,ROUND(cast(new.TOTAL_AMT as REAL) / cast(old.TOTAL_AMT as REAL), 2) * 100 AS '人口増加率'
    FROM PREFECTURE as p
        JOIN POPU_TRANSITION as old ON p.PF_CODE = old.PF_CODE AND old.SURVEY_YEAR = '2015'
        JOIN POPU_TRANSITION as new ON p.PF_CODE = new.PF_CODE AND new.SURVEY_YEAR = '2020'
    WHERE
        (new.TOTAL_AMT - old.TOTAL_AMT) > 0
    ORDER BY 
        ROUND(cast(new.TOTAL_AMT as REAL) / cast(old.TOTAL_AMT as REAL), 2) DESC,
        p.PF_CODE ASC
;