SELECT PRE.PF_CODE AS "都道府県コード"
     , PRE.PF_NAME AS "都道府県名"
     , AMT2015 AS "総人口2015年"
     , AMT2020 AS "総人口2020年"
     , ROUND(100.0 * AMT2020 / AMT2015, 0) AS "人口増加率"
FROM PREFECTURE PRE
LEFT JOIN (SELECT PF_CODE
                , TOTAL_AMT AS AMT2015
           FROM POPU_TRANSITION
           WHERE SURVEY_YEAR = 2015) POP2015
ON PRE.PF_CODE = POP2015.PF_CODE
LEFT JOIN (SELECT PF_CODE
                , TOTAL_AMT AS AMT2020
           FROM POPU_TRANSITION
           WHERE SURVEY_YEAR = 2020) POP2020
ON PRE.PF_CODE = POP2020.PF_CODE
WHERE AMT2020 > AMT2015
ORDER BY 人口増加率 DESC
       , PRE.PF_CODE ASC
;