with entry as (
    select
        PORT_CODE
        ,AMT
    from
        IMMIGRATION
    where
        GROUP_CODE = 120
        and KIND_CODE = 110
)

,leave as (
    select
        PORT_CODE
        ,AMT
    from
        IMMIGRATION
    where
        GROUP_CODE = 120
        and KIND_CODE = 120
)


select
    PORT.PORT_CODE as "港コード"
    ,PORT.PORT_NAME as "港名"
    ,entry.AMT as "入国者数"
    ,leave.AMT as "出国者数"
    ,entry.AMT-leave.AMT as "差分"
from
    PORT
    inner join entry
        on port.PORT_CODE = entry.PORT_CODE
    inner join leave
        on port.PORT_CODE = leave.PORT_CODE

where
    差分 > 0

order by
    差分 desc
    ,港コード desc

;