select 
a.LINE_ID as LINE
,a.SEAT_NO as SEAT_F
,c.SEAT_NO as SEAT_T
from SEAT_RESERVE a
left join SEAT_RESERVE b
on a.LINE_ID = b.LINE_ID
and b.RSV_STATUS = '0'
and  a.SEAT_NO + 1 = b.SEAT_NO
left join SEAT_RESERVE c
on a.LINE_ID = c.LINE_ID
and c.RSV_STATUS = '0'
and  a.SEAT_NO + 2 = c.SEAT_NO
where 
a.LINE_ID is not null
and b.LINE_ID is not null
and c.LINE_ID is not null
order by a.LINE_ID desc,a.SEAT_NO