select data.pf_code as 都道府県コード,
       pf.pf_name as 都道府県名,
       data.amt1 as 総人口2015年,
       data.amt2 as 総人口2020年,
       round((data.amt2 * 100.0) / data.amt1, 0) as 人口増加率
from (
select sum(amt_2015) as amt1,
       sum(amt_2020) as amt2,
       pf_code
  from (
        select 
          case survey_year
            when 2015
                 then total_amt
             else 
                  0
          end as amt_2015,
          case survey_year
            when 2020
                 then total_amt
            else 
                 0
          end as amt_2020,
          pf_code
         from (select * from POPU_TRANSITION where survey_year in (2015, 2020)) data
        )
 group by pf_code
 having amt2 - amt1 > 0
 order by amt2 - amt1 desc
 ) data
 inner join prefecture pf on data.pf_code = pf.pf_code
 order by 人口増加率 desc, 都道府県コード