WITH T1 AS (
SELECT
    *
,	ROW_NUMBER() OVER (PARTITION BY LINE_ID ORDER BY SEAT_NO ASC) AS SEQ1
FROM
	SEAT_RESERVE
WHERE
    RSV_STATUS = '0'
ORDER BY
    LINE_ID, SEAT_NO
),
T2 AS (
SELECT
    LINE_ID
,   (SEAT_NO - SEQ1) AS SEQ2
,   COUNT(*)
,   MIN(SEAT_NO) AS MIN_SEAT_NO
FROM
    T1
GROUP BY
    1, 2
HAVING COUNT(*) >= 3
)
SELECT
    LINE_ID AS ID
,   MIN_SEAT_NO AS SEAT_F
,   MIN_SEAT_NO + 2 AS MIN_SEAT_T
FROM
    T2
ORDER BY
    1 DESC
,    2 ASC