with q1 as (
    select
        LINE_ID as LINE,
        SEAT_NO as SEAT_F,
        SEAT_NO + 2 as SEAT_T,
        RSV_STATUS as stt_1,
        lead(RSV_STATUS, 1) over (
            partition by LINE_ID
            order by
                LINE_ID,
                SEAT_NO
        ) as stt_2,
        lead(RSV_STATUS, 2) over (
            partition by LINE_ID
            order by
                LINE_ID,
                SEAT_NO
        ) as stt_3
    from
        SEAT_RESERVE
)
select
    LINE,
    SEAT_F,
    SEAT_T
from
    q1
where
    stt_1 = '0'
    and stt_2 = '0'
    and stt_3 = '0'
order by
    LINE desc,
    SEAT_F