with tmp as (
select
    line_id
    ,seat_no
    ,rsv_status
    ,sum(cast(rsv_status as integer)) over(partition by line_id order by seat_no rows between 2 preceding and current row) a
    
from
    seat_reserve
)
select
    line_id LINE
    ,seat_no - 2 SEAT_F
    ,seat_no SEAT_T
from 
    tmp
where
    a = 0
    and seat_no not in (1, 2)
order by
    line_id desc, seat_no - 2
;