SELECT
    last.code as 都道府県コード,
    last.name as 都道府県名,
    last.a as 総人口2015年,
    last.b 総人口2020年,
    ROUND((cast(last.b as REAL) /cast(last.a as REAL) * 100)) as 人口増加率
FROM
    (
        SELECT DISTINCT
            pop.PF_CODE as code,
            pre.PF_NAME as name,
            (
                SELECT 
                    SUM(TOTAL_AMT)
                FROM     
                    POPU_TRANSITION sub
                WHERE
                    sub.SURVEY_YEAR = 2015
                AND sub.PF_CODE =  pop.PF_CODE
                GROUP BY 
                    sub.SURVEY_YEAR,
                    sub.PF_CODE
            ) as a,
            (
                SELECT 
                    SUM(TOTAL_AMT)
                FROM     
                    POPU_TRANSITION sub
                WHERE
                    sub.SURVEY_YEAR = 2020
                AND sub.PF_CODE =  pop.PF_CODE
                GROUP BY 
                    sub.SURVEY_YEAR,
                    sub.PF_CODE
            ) as b
        FROM     
            POPU_TRANSITION pop
        LEFT JOIN
            PREFECTURE pre
        ON pop.PF_CODE = pre.PF_CODE
    ) as last
WHERE
    last.a < last.b
ORDER BY
人口増加率 DESC,
都道府県コード