CREATE TEMPORARY TABLE TMP_COME as SELECT PORT_CODE, AMT as "COME_AMT" from IMMIGRATION where GROUP_CODE = "120" and KIND_CODE = "110";
CREATE TEMPORARY TABLE TMP_GO as SELECT PORT_CODE, AMT as "GO_AMT" from IMMIGRATION where GROUP_CODE = "120" and KIND_CODE = "120";

select TMP_COME.PORT_CODE as "港コード", PORT_NAME as "港名", TMP_COME.COME_AMT as "入国者数", TMP_GO.GO_AMT as "出国者数", TMP_COME.COME_AMT - TMP_GO.GO_AMT as "差分"
from TMP_COME inner join PORT on TMP_COME.PORT_CODE = PORT.PORT_CODE inner join TMP_GO on TMP_COME.PORT_CODE = TMP_GO.PORT_CODE where "差分" > 0 order by "差分" desc, "港コード" desc