select
    LINE_ID as LINE,
    MIN as SEAT_F,
    MAX as SEAT_T
from
    (
        select
            LINE_ID,
            min(SEAT_NO) as MIN,
            max(SEAT_NO) as MAX,
            count(SEAT_NO) as COUNT,
            rn
        from(
            select
                *,
                SEAT_NO - (row_number() over (partition by LINE_ID order by SEAT_NO asc)) rn
            from
                (
                select
                    *
                from
                    SEAT_RESERVE
                where
                    RSV_STATUS = 0
                )
            )
        group by LINE_ID,rn
    )
where COUNT = 3