select
    PF.PF_CODE as "都道府県コード",
    PF.PF_NAME as "都道府県名",
    MIN(
        CASE
            when SURVEY_YEAR = 2015 then POP.TOTAL_AMT
        end
    ) as "総人口2015年",
    MIN(
        CASE
            when SURVEY_YEAR = 2020 then POP.TOTAL_AMT
        end
    ) as "総人口2020年",
    round(
        cast(
            MIN(
                CASE
                    when SURVEY_YEAR = 2020 then POP.TOTAL_AMT
                end
            ) as real
        ) / MIN(
            CASE
                when SURVEY_YEAR = 2015 then POP.TOTAL_AMT
            end
        ) * 100
    ) as "人口増加率"
from
    PREFECTURE as PF
    join POPU_TRANSITION as POP on PF.PF_CODE = POP.PF_CODE
    and (
        POP.SURVEY_YEAR = 2015
        or POP.SURVEY_YEAR = 2020
    )
group by
    PF.PF_CODE
having round(
        cast(
            MIN(
                CASE
                    when SURVEY_YEAR = 2020 then POP.TOTAL_AMT
                end
            ) as real
        ) / MIN(
            CASE
                when SURVEY_YEAR = 2015 then POP.TOTAL_AMT
            end
        ) * 100
    ) >= 100
order by
    "人口増加率" desc,
    "都道府県コード" asc;