SELECT
    PF_CODE
    ,CASE WHEN rank_amt=1 THEN NATION_CODE END as first_code
    ,CASE WHEN rank_amt=1 THEN AMT END as first_amt
FROM
(
    SELECT
        PF_CODE
        ,NATION_CODE
        ,AMT
        ,rank() over(partition by PF_CODE order by AMT DESC, NATION_CODE) as rank_amt
    FROM
        FOREIGNER
    WHERE
        NATION_CODE != 113
)
WHERE
    rank_amt=1;