select
    pt.PF_CODE AS "都道府県コード",
    p.PF_NAME AS "都道府県名",
    SUM(CASE WHEN pt.SURVEY_YEAR = 2015 THEN pt.TOTAL_AMT ELSE 0 END) AS "総人口2015年",
    SUM(CASE WHEN pt.SURVEY_YEAR = 2020 THEN pt.TOTAL_AMT ELSE 0 END) AS "総人口2020年",
    round(cast(SUM(CASE WHEN pt.SURVEY_YEAR = 2020 THEN pt.TOTAL_AMT ELSE 0 END) as real) / 
        cast(SUM(CASE WHEN pt.SURVEY_YEAR = 2015 THEN pt.TOTAL_AMT ELSE 0 END) as real) * 100) AS "人口増加率"
from
    POPU_TRANSITION as pt
    INNER JOIN PREFECTURE as p
        ON pt.PF_CODE = p.PF_CODE
group by
    pt.PF_CODE,
    p.PF_NAME
having
    "人口増加率" > 100
    
order by
    "人口増加率" desc,
    pt.PF_CODE asc