with zero_sr as (select *
from SEAT_RESERVE as sr
where rsv_status = '0'
),

result as (select
zsr1.line_id as LINE,
zsr2.seat_no as SEAT_F,
zsr1.seat_no as SEAT_T
from zero_sr as zsr1
left join zero_sr as zsr2
on zsr1.line_id = zsr2.line_id and zsr1.seat_no = zsr2.seat_no + 2
where zsr1.seat_no is not NULL and zsr2.seat_no is not NULL
order by LINE desc, SEAT_F asc
)

select
r.*
from result as r
;