select
    sv1.line_id as LINE,
    sv1.seat_no as SEAT_F,
    max(sv2.seat_no) as SEAT_T
from SEAT_RESERVE as sv1
inner join SEAT_RESERVE sv2 on sv1.line_id=sv2.line_id
where sv2.seat_no between sv1.seat_no and sv1.seat_no+(3-1)
group by sv1.line_id, sv1.seat_no
having COUNT(NULLIF(SV2.RSV_STATUS, '1')) = 3 
order by SV1.LINE_ID DESC, SV1.SEAT_NO ASC;