WITH ConsecutiveSeats AS (
  SELECT 
    LINE_ID,
    SEAT_NO AS SEAT_F,
    LEAD(SEAT_NO, 1) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS SEAT_2,
    LEAD(SEAT_NO, 2) OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS SEAT_T,
    ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO) AS RN
  FROM SEAT_RESERVE
  WHERE RSV_STATUS = '0'
),
FilteredSeats AS (
  SELECT *
  FROM ConsecutiveSeats
  WHERE SEAT_2 = SEAT_F + 1 AND SEAT_T = SEAT_F + 2
)
SELECT 
  LINE_ID AS LINE,
  MIN(SEAT_F) AS SEAT_F,
  MIN(SEAT_T) AS SEAT_T
FROM FilteredSeats
GROUP BY LINE_ID
ORDER BY LINE_ID DESC, SEAT_F ASC;