SELECT
 P.PF_CODE AS "都道府県コード",
 P.PF_NAME AS "都道府県名",
 PT.TOTAL_AMT AS "総人口2015年",
 PT2020.TOTAL_AMT AS "総人口2020年",
 ROUND((CAST(PT2020.TOTAL_AMT AS REAL)/CAST(PT.TOTAL_AMT AS REAL)) * 100) AS "人口増加率"
FROM
 PREFECTURE AS P
INNER JOIN POPU_TRANSITION AS PT ON PT.PF_CODE = P.PF_CODE
INNER JOIN POPU_TRANSITION AS PT2020 ON
 PT2020.PF_CODE = P.PF_CODE
 AND PT2020.SURVEY_YEAR = 2020
WHERE PT.SURVEY_YEAR = 2015
AND PT.TOTAL_AMT < PT2020.TOTAL_AMT
ORDER BY "人口増加率" DESC, P.PF_CODE ASC;