WITH
    P2015 AS (SELECT PF_CODE, IFNULL(TOTAL_AMT, 0) AS TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2015),
    P2020 AS (SELECT PF_CODE, IFNULL(TOTAL_AMT, 0) AS TOTAL_AMT FROM POPU_TRANSITION WHERE SURVEY_YEAR = 2020)
SELECT P.PF_CODE AS '都道府県コード', P.PF_NAME AS '都道府県名', P2015.TOTAL_AMT AS '総人口2015年', P2020.TOTAL_AMT AS '総人口2020年', P2020.TOTAL_AMT*100/P2015.TOTAL_AMT AS '人口増加率' FROM PREFECTURE P, P2015, P2020 WHERE P.PF_CODE = P2015.PF_CODE AND P.PF_CODE = P2020.PF_CODE AND P2015.TOTAL_AMT < P2020.TOTAL_AMT ORDER BY 人口増加率 DESC, 都道府県コード