WITH flagged AS (
  SELECT
    *
    , CASE 
      WHEN RSV_STATUS = '0' AND 
           LAG(RSV_STATUS, 1) OVER(PARTITION BY LINE_ID ORDER BY SEAT_NO) = '0' AND 
           LAG(RSV_STATUS, 2) OVER(PARTITION BY LINE_ID ORDER BY SEAT_NO) = '0' 
      THEN 1 
      ELSE 0 
    END AS is_flag_sequence
    ,  CASE 
      WHEN RSV_STATUS = '0'
        THEN SEAT_NO
      ELSE NULL
    END AS zero_SEAT_NO
  FROM SEAT_RESERVE
),
grouped AS (
  SELECT
    LINE_ID
    , MIN(zero_SEAT_NO) OVER(PARTITION BY LINE_ID, is_flag_sequence) as F_SEAT_NO
    , MAX(zero_SEAT_NO) OVER(PARTITION BY LINE_ID, is_flag_sequence) as T_SEAT_NO
  FROM flagged
  WHERE is_flag_sequence = 1
)
SELECT DISTINCT * FROM grouped 
WHERE F_SEAT_NO IS NOT NULL AND T_SEAT_NO IS NOT NULL
ORDER BY 1 DESC, 2 ASC;