select
     NO1.LINE_ID as LINE
    ,NO1.SEAT_NO as SEAT_F
    ,NO3.SEAT_NO as SEAT_T
from SEAT_RESERVE as NO1
inner join SEAT_RESERVE as NO2
    on  NO2.LINE_ID = NO1.LINE_ID
    and NO2.SEAT_NO = NO1.SEAT_NO+1
    and NO2.RSV_STATUS = 0
inner join SEAT_RESERVE as NO3
    on  NO3.LINE_ID = NO1.LINE_ID
    and NO3.SEAT_NO = NO1.SEAT_NO+2
    and NO3.RSV_STATUS = 0
where NO1.RSV_STATUS = 0
order by NO1.LINE_ID desc
        ,NO1.SEAT_NO asc;