SELECT
    T15.PF_CODE AS 都道府県コード
  , PF_NAME AS 都道府県名
  , TOTAL_15 AS 総人口2015年
  , TOTAL_20 AS 総人口2020年
  , Round(Cast(TOTAL_20 as real)/Cast(TOTAL_15 as real) * 100) AS 人口増加率
FROM
    PREFECTURE PRE
,
(
    SELECT
        PF_CODE
      , TOTAL_AMT AS TOTAL_15
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2015
) T15
,
(
    SELECT
        PF_CODE
      , TOTAL_AMT AS TOTAL_20
    FROM
        POPU_TRANSITION
    WHERE
        SURVEY_YEAR = 2020
) T20
WHERE
    T15.PF_CODE = T20.PF_CODE
AND PRE.PF_CODE = T15.PF_CODE
AND TOTAL_15 <= TOTAL_20
ORDER BY
    人口増加率 Desc
  , 都道府県コード Asc