select
    PREFECTURE.PF_CODE as "都道府県コード",
    PF_NAME as "都道府県名",
    PT2015.TOTAL_AMT as "総人口2015年",
    PT2020.TOTAL_AMT as "総人口2020年",
    round(100.0 * PT2020.TOTAL_AMT / PT2015.TOTAL_AMT) as "人口増加率"
from
    POPU_TRANSITION as PT2015,
    POPU_TRANSITION as PT2020,
    PREFECTURE
where
    PT2015.PF_CODE = PREFECTURE.PF_CODE and
    PT2015.SURVEY_YEAR = 2015 and
    PT2020.PF_CODE = PREFECTURE.PF_CODE and
    PT2020.SURVEY_YEAR = 2020 and
    PT2020.TOTAL_AMT > PT2015.TOTAL_AMT
order by
    "人口増加率" desc,
    "都道府県コード";