select
    PORT.PORT_CODE as "港コード",
    PORT.PORT_NAME as "港名",
    sum(
        case
            when IMMIGRATION.KIND_CODE = "110" then IMMIGRATION.AMT
        end
    ) as "入国者数",
    sum(
        case
            when IMMIGRATION.KIND_CODE = "120" then IMMIGRATION.AMT
        end
    ) as "出国者数",
    sum(
        case
            when IMMIGRATION.KIND_CODE = "110" then IMMIGRATION.AMT
            when IMMIGRATION.KIND_CODE = "120" then - IMMIGRATION.AMT
        end
    ) as "差分"
from
    PORT
    join IMMIGRATION on PORT.PORT_CODE = IMMIGRATION.PORT_CODE
group by
    IMMIGRATION.PORT_CODE
having
    sum(
        case
            when IMMIGRATION.KIND_CODE = "110" then IMMIGRATION.AMT
            when IMMIGRATION.KIND_CODE = "120" then - IMMIGRATION.AMT
        end
    ) > 0
order by
    "差分" desc,
    "港コード" asc;