select
    IMG.PORT_CODE as "港コード"
    , PORT_NAME as "港名"
    , IMG.AMT as "入国者数"
    , IMGOUT.AMT as "出国者数"
    , IMG.AMT - IMGOUT.AMT as "差分"
from
    IMMIGRATION as IMG
inner join
    IMMIGRATION as IMGOUT
on
    IMG.PORT_CODE = IMGOUT.PORT_CODE
and
    IMG.KIND_CODE = "110"
and
    IMGOUT.KIND_CODE = "120"
and
    IMG.GROUP_CODE = "120"
and
    IMGOUT.GROUP_CODE = "120"
inner join
    PORT
on
    IMG.PORT_CODE = PORT.PORT_CODE
where
    IMG.AMT > IMGOUT.AMT
order by
    "差分" desc
    , IMG.PORT_CODE desc;