select
sr1.LINE_ID as LINE,
sr1.SEAT_NO as SEAT_F,
sr1.SEAT_NO + 2 as SEAT_T
from
SEAT_RESERVE as sr1
inner join SEAT_RESERVE sr2
on
sr1.LINE_ID = sr2.LINE_ID and sr1.SEAT_NO + 1 = sr2.SEAT_NO
inner join SEAT_RESERVE sr3
on
sr1.LINE_ID = sr3.LINE_ID and sr1.SEAT_NO + 2 = sr3.SEAT_NO
where
sr1.RSV_STATUS = sr2.RSV_STATUS and sr2.RSV_STATUS = sr3.RSV_STATUS and sr1.RSV_STATUS = '0'
order by
sr1.LINE_ID DESC, sr1.SEAT_NO