--連続した3つの席
--列IDと先頭の座席番号と3番目の座席番号


select
LINE_ID as LINE
,SEAT_NO-2 as SEAT_F
,SEAT_NO as SEAT_T
from
(
select
LINE_ID
,SEAT_NO
,sum(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