with data as (
    select
        LINE_ID,
        SEAT_NO,
        case
            when count(RSV_STATUS) over (
                partition by LINE_ID
                order by
                    LINE_ID,
                    SEAT_NO rows between 2 preceding
                    and current row
            ) <> 3 then null
            else sum(1 - RSV_STATUS) over (
                partition by LINE_ID
                order by
                    LINE_ID,
                    SEAT_NO rows between 2 preceding
                    and current row
            )
        end as S
    from
        SEAT_RESERVE
)
select
    LINE_ID as LINE,
    SEAT_NO -2 as SEAT_F,
    SEAT_NO as SEAT_T
from
    data
where
    S == 3
order by
    LINE desc,
    SEAT_F asc