SELECT
LINE_ID,
SEAT_NO AS SEAT_F,
SEAT_NO + 2 AS SEAT_T
FROM(
SELECT
LINE_ID,
SEAT_NO,
RSV_STATUS,
row_number() over (partition by LINE_ID  order by LINE_ID asc) AS LINE_RENBAN,
row_number() over (partition by SEAT_NO order by SEAT_NO asc) AS SEAT_RENBAN,
row_number() over (partition by LINE_ID,RSV_STATUS order by LINE_ID asc,SEAT_NO asc) AS FLG_RENBAN,
row_number() over (partition by LINE_ID  order by LINE_ID asc) - row_number() over (partition by LINE_ID,RSV_STATUS order by LINE_ID asc,SEAT_NO asc) AS SABUN 
FROM
SEAT_RESERVE
ORDER BY LINE_ID,SEAT_NO
)
WHERE RSV_STATUS = '0' 
GROUP BY 
SEAT_RENBAN,SABUN
HAVING  COUNT(LINE_ID)  >= 3
ORDER BY LINE_ID DESC,SEAT_F ASC