select
    PREFECTURE.PF_CODE as '都道府県コード',
    PREFECTURE.PF_NAME as '都道府県名',
    amt_2015.TOTAL_AMT_2015 as '総人口2015年',
    amt_2020.TOTAL_AMT_2020 as '総人口2020年',
    ROUND(amt_2020.TOTAL_AMT_2020*100.0/amt_2015.TOTAL_AMT_2015) as '人口増加率'
from
    (
        (
            select * from PREFECTURE
        ) as PREFECTURE
        left outer join(
            select
                PF_CODE,
                TOTAL_AMT as TOTAL_AMT_2015
            from
                POPU_TRANSITION
            where
                SURVEY_YEAR = 2015
        ) as amt_2015 on PREFECTURE.PF_CODE = amt_2015.PF_CODE
        left outer join (
            select
                PF_CODE,
                TOTAL_AMT as TOTAL_AMT_2020
            from
                POPU_TRANSITION
            where
                SURVEY_YEAR = 2020
        ) as amt_2020 on PREFECTURE.PF_CODE = amt_2020.PF_CODE
    )
where
    amt_2020.TOTAL_AMT_2020>amt_2015.TOTAL_AMT_2015
order by
    amt_2020.TOTAL_AMT_2020*100.0/amt_2015.TOTAL_AMT_2015 desc,
    PREFECTURE.PF_CODE asc