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