SELECT PF_CODE AS 都道府県コード, pf.PF_NAME AS 都道府県名, tr2015.TOTAL_AMT AS 総人口2015年, tr2020.TOTAL_AMT AS 総人口2020年, round(tr2020.TOTAL_AMT*100.0/tr2015.TOTAL_AMT) AS 人口増加率 FROM PREFECTURE AS pf
INNER JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015) AS tr2015 USING(PF_CODE)
INNER JOIN (SELECT PF_CODE, TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020) AS tr2020 USING(PF_CODE)
WHERE tr2015.TOTAL_AMT<tr2020.TOTAL_AMT ORDER BY 人口増加率 desc, PF_CODE ASC;