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