with T1 as(
    select
        line_id
        ,seat_no+1 as sn
    from seat_reserve
    where rsv_status = '0'
)
,T2 as(
     select
        line_id
        ,seat_no+2 as sn
    from seat_reserve   
    where rsv_status = '0'
)
select
    T.line_id as LINE
    ,T.seat_no-2 as SEAT_F
    ,T2.sn as SEAT_T
from seat_reserve as T
inner join T1
on T.seat_no=T1.sn
and T.line_id=T1.line_id
inner join T2
on T.seat_no=T2.sn
and T.line_id=T2.line_id
where T.rsv_status = 0
order by T.line_id desc,seat_f