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