select N.PF_CODE as 都道府県コード, PF_NAME as 都道府県名, O.TOTAL_AMT as 総人口2015年, N.TOTAL_AMT as 総人口2020年, round((N.TOTAL_AMT +0.5)* 100/ O.TOTAL_AMT, 0) as 人口増加率  from (select * from POPU_TRANSITION where SURVEY_YEAR = 2020) as N, (select * from POPU_TRANSITION where SURVEY_YEAR = 2015) as O on N.PF_CODE = O.PF_CODE, PREFECTURE on PREFECTURE.PF_CODE = O.PF_CODE where N.TOTAL_AMT > O.TOTAL_AMT order by 人口増加率 desc, 都道府県コード;