select 
im.PORT_CODE as "港コード",
po.PORT_NAME as "港名",
--(case when im.kind_code = 110 then im.amt else 0 end) as "入国者数",
--(case when im.kind_code = 120 then im.amt else 0 end) as "出国者数",
im1.amt as "入国者数",
im2.amt as "出国者数",
("入国者数" - "出国者数") as "差分"
from immigration as im
inner join port as po on po.port_code = im.port_code 
inner join grp as gr on gr.group_code = im.group_code
inner join immigration as im1 on po.port_code = im1.port_code and gr.group_code = im1.group_code and im1.kind_code = 110
inner join immigration as im2 on po.port_code = im2.port_code and gr.group_code = im2.group_code and im2.kind_code = 120
where im.group_code = 120
order by "差分" desc, im.port_code desc