with
FOREIGN_IMMIGRATION as (
select
    PORT_CODE 
    , sum(IIF(KIND_CODE = 110, AMT, 0)) as IN_AMT
    , sum(IIF(KIND_CODE = 120, AMT, 0)) as EX_AMT
from
    IMMIGRATION
where
    GROUP_CODE = 120
group by
    PORT_CODE 

)

select
    PORT_CODE as 港コード
    , PORT_NAME as 港名
    , IN_AMT as 入国者数
    , EX_AMT as 出国者数
    , IN_AMT - EX_AMT as 差分
from
    FOREIGN_IMMIGRATION
join
    PORT
    USING(PORT_CODE)
where
    IN_AMT > EX_AMT
order by
    差分 desc , 港コード desc