WITH A AS (
SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR=2015
)
,
B AS (
SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR=2020
)

SELECT A.PF_CODE AS 都道府県コード, C.PF_NAME AS 都道府県名, A.TOTAL_AMT AS 総人口2015年, B.TOTAL_AMT AS 総人口2020年, 
       round(100.0*B.TOTAL_AMT/A.TOTAL_AMT) AS 人口増加率
FROM A JOIN B ON A.PF_CODE=B.PF_CODE
JOIN PREFECTURE AS C ON A.PF_CODE=C.PF_CODE
WHERE round(100.0*B.TOTAL_AMT/A.TOTAL_AMT) >= 100
ORDER BY round(100.0*B.TOTAL_AMT/A.TOTAL_AMT) DESC, A.PF_CODE