SELECT p.PF_CODE AS 都道府県コード,
       p.PF_NAME AS 都道府県名,
       t2015.TOTAL_AMT AS 総人口2015年,
       t2020.TOTAL_AMT AS 総人口2020年,
       ROUND((t2020.TOTAL_AMT - t2015.TOTAL_AMT) * 100.0 / t2015.TOTAL_AMT) + 100 AS 人口増加率
FROM PREFECTURE p
LEFT OUTER JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015) t2015 ON p.PF_CODE = t2015.PF_CODE
LEFT OUTER JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020) t2020 ON p.PF_CODE = t2020.PF_CODE
WHERE t2020.TOTAL_AMT > t2015.TOTAL_AMT
ORDER BY 人口増加率 DESC, 都道府県コード ASC