select 
    PF_CODE as "都道府県コード"
    , PF_NAME as "都道府県名"
    , TOTAL_AMT as "総人口2015年"
    , "2020_TOTAL_AMT" as "総人口2020年"
    , round("2020_TOTAL_AMT" *100.0 / TOTAL_AMT,0) as "人口増加率"
from POPU_TRANSITION
inner join  (
    select PF_CODE, TOTAL_AMT as "2020_TOTAL_AMT"
    from POPU_TRANSITION 
    where SURVEY_YEAR=2020) using(PF_CODE)
inner join PREFECTURE using(PF_CODE)
where SURVEY_YEAR=2015
    and ("2020_TOTAL_AMT" - TOTAL_AMT) > 0
order by "人口増加率" desc, "都道府県コード"