SELECT
    p.PF_CODE as '都道府県コード',
    p.PF_NAME as '都道府県名',
    pt.p2015 as '総人口2015年',
    pt.p2020 as '総人口2020年',
    ROUND(CAST(pt.p2020 as real) / CAST(pt.p2015 as real) * 100) as '人口増加率'
FROM PREFECTURE as p
INNER JOIN (
    SELECT
        PF_CODE,
        MAX(CASE WHEN SURVEY_YEAR = 2015 THEN TOTAL_AMT ELSE 0 END) as p2015,
        MAX(CASE WHEN SURVEY_YEAR = 2020 THEN TOTAL_AMT ELSE 0 END) as p2020
    FROM POPU_TRANSITION
    WHERE SURVEY_YEAR IN(2015, 2020)
    GROUP BY PF_CODE
) as pt
ON p.PF_CODE = pt.PF_CODE
WHERE p2020 > p2015
ORDER BY 5 DESC, 1