SELECT pf.PF_CODE AS "都道府県コード"
     , pf.PF_NAME AS "都道府県名"
     , tr2015.TOTAL_AMT AS "総人口2015年"
     , tr2020.TOTAL_AMT as "総人口2020年"
     , ROUND((CAST(tr2020.TOTAL_AMT AS REAL) / tr2015.TOTAL_AMT)*100) AS "人口増加率"
  FROM PREFECTURE pf
       LEFT OUTER JOIN (
                       SELECT tr.PF_CODE
                            , tr.SURVEY_YEAR
                            , tr.TOTAL_AMT
                            , tr.MALE_AMT
                            , tr.FEMALE_AMT
                         FROM POPU_TRANSITION tr
                        WHERE tr.SURVEY_YEAR = 2015
                       ) tr2015
                    ON pf.PF_CODE = tr2015.PF_CODE
       LEFT OUTER JOIN (
                       SELECT tr.PF_CODE
                            , tr.SURVEY_YEAR
                            , tr.TOTAL_AMT
                            , tr.MALE_AMT
                            , tr.FEMALE_AMT
                         FROM POPU_TRANSITION tr
                        WHERE tr.SURVEY_YEAR = 2020
                       ) tr2020
                    ON pf.PF_CODE = tr2020.PF_CODE
 WHERE tr2015.TOTAL_AMT < tr2020.TOTAL_AMT
 ORDER BY 5 desc
        , 1 asc
;