with TMP as (
    select
    	F.PF_CODE
    	, P.PF_NAME
    	, N.NATION_NAME
    	, sum(AMT) as SUM_AMT
    from FOREIGNER as F
    inner join NATIONALITY as N using(NATION_CODE)
    inner join PREFECTURE as P using(PF_CODE)
    group by F.PF_CODE, F.NATION_CODE
)
select
    PF_CODE
    , PF_NAME
    , NATION_NAME as FIRST_NAME
    , SUM_AMT as FIRST_AMT
    , max(NATION_NAME)
        over(order by SUM_AMT desc rows between 1 following and 1 following) as SECOND_NAME
    , max(SUM_AMT)
        over(order by SUM_AMT desc rows between 1 following and 1 following) as SECOND_AMT
from TMP