SELECT P.PF_CODE as 都道府県コード, P.PF_NAME as 都道府県名, POP15.TOTAL_AMT as 総人口2015年, POP20.TOTAL_AMT as 総人口2020年,
        round((POP20.TOTAL_AMT*100.0) / POP15.TOTAL_AMT, 0) as 人口増加率
    FROM PREFECTURE as P
        JOIN (SELECT TOTAL_AMT, PF_CODE FROM POPU_TRANSITION WHERE SURVEY_YEAR=2015) as POP15 ON P.PF_CODE=POP15.PF_CODE
        JOIN (SELECT TOTAL_AMT, PF_CODE FROM POPU_TRANSITION WHERE SURVEY_YEAR=2020) as POP20 ON P.PF_CODE=POP20.PF_CODE
    WHERE POP15.TOTAL_AMT < POP20.TOTAL_AMT
    ORDER BY 人口増加率 desc, 都道府県コード