select
LINE_ID as LINE
,SEAT_NO-2 as SEAT_F
,SEAT_NO as SEAT_T
from
(
select
LINE_ID
,SEAT_NO
,sum(1-RSV_STATUS) over(partition by LINE_ID order by SEAT_NO rows between 2 preceding and current row) as NUM
from SEAT_RESERVE
)
where NUM =3
order by
1 desc,2 asc