WITH NO_RESERVE AS (
select LINE_ID, SEAT_NO from seat_reserve where RSV_STATUS=0
)
, NO_RESERVE_1 AS (
select s.LINE_ID, s.SEAT_NO, not_s.SEAT_NO as n_no from seat_reserve s, NO_RESERVE not_s where s.LINE_ID=not_s.LINE_ID and s.SEAT_NO=not_s.SEAT_NO+1 and s.RSV_STATUS=0
)
, NO_RESERVE_2 AS (
select s.LINE_ID, s.SEAT_NO, not_s.SEAT_NO as n_no from seat_reserve s, NO_RESERVE not_s where s.LINE_ID=not_s.LINE_ID and s.SEAT_NO=not_s.SEAT_NO+2 and s.RSV_STATUS=0
)
, REVTBL AS (
select NO_RESERVE.LINE_ID, NO_RESERVE.SEAT_NO as SEAT_F, NO_RESERVE_1.SEAT_NO as SEAT_M, NO_RESERVE_2.SEAT_NO as SEAT_T 
  from NO_RESERVE LEFT OUTER JOIN NO_RESERVE_1 ON NO_RESERVE.LINE_ID=NO_RESERVE_1.LINE_ID AND NO_RESERVE.SEAT_NO=NO_RESERVE_1.N_NO
                  LEFT OUTER JOIN NO_RESERVE_2 ON NO_RESERVE.LINE_ID=NO_RESERVE_2.LINE_ID AND NO_RESERVE.SEAT_NO=NO_RESERVE_2.N_NO
)
select REVTBL.LINE_ID, REVTBL.SEAT_F, REVTBL.SEAT_T from REVTBL
where REVTBL.SEAT_F is not null
  and REVTBL.SEAT_M is not null
  and REVTBL.SEAT_T is not null
order by LINE_ID desc, SEAT_F
;