select PF_CODE as 都道府県コード, PF_NAME as 都道府県名,
    TOTAL_AMT as 総人口2015年, total_now as 総人口2020年,
    ROUND(100.0 * total_now / TOTAL_AMT) as 人口増加率
    from POPU_TRANSITION
    left outer join
        (select PF_CODE as target, PF_NAME, PF_NAME as rate from PREFECTURE) on PF_CODE = target
    left outer join
        (select PF_CODE as target2, TOTAL_AMT as total_now from POPU_TRANSITION where SURVEY_YEAR = 2020) on PF_CODE = target2
    where SURVEY_YEAR = 2015 and TOTAL_AMT < total_now
    order by 人口増加率 desc, PF_CODE asc;