SELECT PF_CODE "都道府県コード"
, PF_NAME "都道府県名"
, p2015.TOTAL_AMT "総人口2015年"
, p2020.TOTAL_AMT "総人口2020年"
, ROUND(p2020.TOTAL_AMT * 100.0 / p2015.TOTAL_AMT) "人口増加率"
FROM (SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020) p2020
INNER JOIN (SELECT * FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015) p2015 USING(PF_CODE)
INNER JOIN PREFECTURE USING(PF_CODE)
WHERE p2015.TOTAL_AMT < p2020.TOTAL_AMT
ORDER BY 5 DESC, 1