select
    PORT_CODE as "港コード",
    PORT_NAME as "港名",
    sum_into_amt as "入国者数",
    sum_outo_amt as "出国者数",
    sum_into_amt - sum_outo_amt as "差分"
from (
    select
        immigration.port_code,
        port_name,
        sum(iif(immigration.group_code = "120" and kind_code = "110", amt, 0)) as sum_into_amt,
        sum(iif(immigration.group_code = "120" and kind_code = "120", amt, 0)) as sum_outo_amt
    from
        immigration
    inner join
        port
    on
        immigration.port_code = port.port_code
    inner join
        grp
    on
        immigration.group_code = grp.group_code
    group by
        immigration.port_code
)
where
    sum_into_amt > sum_outo_amt
order by
    "差分" desc,
    "港コード" desc