select p_2015.pf_code as "都道府県コード", pf_name as "都道府県名",
p_2015.total_amt as "総人口2015年", p_2020.total_amt as "総人口2020年",
round(p_2020.total_amt * 1.0 / p_2015.total_amt * 100, 0) as "人口増加率"
from POPU_TRANSITION as p_2015
inner join POPU_TRANSITION as p_2020 on p_2015.pf_code = p_2020.pf_code
inner join PREFECTURE on PREFECTURE.pf_code = p_2015.pf_code
where p_2015.survey_year = 2015
and p_2020.survey_year = 2020
group by p_2015.pf_code having 人口増加率 > 100
order by 人口増加率 desc, 都道府県コード