SELECT
    BF.CODE AS 都道府県コード,
    BF.NAME AS 都道府県名,
    BF.AMT AS 総人口2015年,
    AF.AMT AS 総人口2020年,
    ROUND (CAST (AF.AMT AS REAL) / CAST (BF.AMT AS REAL), 0
        ) * 100 AS 人口増加率
        FROM
            (SELECT
                POP.SURVEY_YEAR AS YERE,
                PF.PF_CODE AS CODE,
                PF.PF_NAME AS NAME,
                POP.FEMALE_AMT AS AMT
                    FROM  POPU_TRANSITION AS POP
                    JOIN PREFECTURE AS PF
                        ON POP.PF_CODE = PF.PF_CODE
                    WHERE POP.SURVEY_YEAR = 2015
            ) AS BF
        JOIN
            (SELECT
                POP.SURVEY_YEAR AS YERE,
                PF.PF_CODE AS CODE,
                PF.PF_NAME AS NAME,
                POP.FEMALE_AMT AS AMT
                    FROM  POPU_TRANSITION AS POP
                    JOIN PREFECTURE AS PF
                        ON POP.PF_CODE = PF.PF_CODE
                    WHERE POP.SURVEY_YEAR = 2020
            ) AS AF
        WHERE BF.AMT < AF.AMT
        ORDER BY
            人口増加率 DESC,
            都道府県コード