SELECT 
    PF_CODE AS "都道府県コード",
    PF_NAME AS "都道府県名",
    TOTAL_AMT AS "総人口2020年",
    PREV_TOTAL_AMT AS "総人口2015年",
    ROUND(CAST(TOTAL_AMT - PREV_TOTAL_AMT AS FLOAT)/PREV_TOTAL_AMT *100, 0) AS "人口増加率"
FROM 
(
    SELECT
        pop.SURVEY_YEAR,
        pop.PF_CODE, 
        p.PF_NAME,
        pop.TOTAL_AMT,
        LAG(pop.TOTAL_AMT, 1) OVER (PARTITION BY pop.PF_CODE ORDER BY pop.SURVEY_YEAR) AS PREV_TOTAL_AMT
    FROM POPU_TRANSITION AS pop
    JOIN PREFECTURE as p
    ON pop.PF_CODE = p.PF_CODE
) AS pop_tra
WHERE SURVEY_YEAR = 2020
ORDER BY "都道府県コード", "人口増加率" desc;