SELECT A_PORT_CODE AS "港コード", PORT_NAME AS "港名", AMT110 AS 入国者数, AMT120 AS 出国者数, (AMT110 - AMT120) as 差分 FROM (
        SELECT PORT_CODE AS A_PORT_CODE, AMT as "AMT110" FROM IMMIGRATION
            WHERE KIND_CODE = 110
    )
    INNER JOIN (
            SELECT PORT_CODE AS B_PORT_CODE, AMT as "AMT120" FROM IMMIGRATION
        ) ON A_PORT_CODE = B_PORT_CODE
    INNER JOIN PORT ON A_PORT_CODE = PORT.PORT_CODE
    ORDER BY 差分 DESC, A_PORT_CODE DESC