select c.*,
round((cast((c."総人口2020年") as 'real') * 100 / c."総人口2015年"),0) as "人口増加率"
from 
(
select 
a."PF_CODE" as "都道府県コード",
a."PF_NAME" as "都道府県名",
(select b."TOTAL_AMT" from "POPU_TRANSITION" as b where b."PF_CODE" = a."PF_CODE" and b."SURVEY_YEAR" = 2015) as "総人口2015年",
(select b."TOTAL_AMT" from "POPU_TRANSITION" as b where b."PF_CODE" = a."PF_CODE" and b."SURVEY_YEAR" = 2020) as "総人口2020年"
from "PREFECTURE" as a where "総人口2015年" < "総人口2020年"
) as c
order by "人口増加率" desc,"都道府県コード" asc