select
    t1.PF_CODE as '都道府県コード'
    , t2.PF_NAME as '都道府県名'
    , sum(t1.AMT) as '1位 国名'
    , sum(t1.AMT) as '1位 人数'
    , sum(t1.AMT) as '2位 国名'
    , sum(t1.AMT) as '2位 人数'
    , sum(t1.AMT) as '3位 国名'
    , sum(t1.AMT) as '3位 人数'
    , sum(t1.AMT) as '合計人数'
from FOREIGNER t1
inner join PREFECTURE t2
on t1.PF_CODE = t2.PF_CODE
inner join NATIONALITY t3
on t1.NATION_CODE = t3.NATION_CODE
where t1.NATION_CODE != '113'
group by t1.PF_CODE