SELECT 
T1.LINE_ID AS LINE,
T1.SEAT_NO AS SEAT_F,
T3.SEAT_NO AS SEAT_T
FROM
SEAT_RESERVE T1
INNER JOIN
SEAT_RESERVE T2 
ON 
T2.LINE_ID = T1.LINE_ID AND
T2.SEAT_NO = T1.SEAT_NO + 1 AND
T2.RSV_STATUS ='0'
INNER JOIN
SEAT_RESERVE T3
ON 
T3.LINE_ID = T1.LINE_ID AND
T3.SEAT_NO = T1.SEAT_NO + 2 AND
T3.RSV_STATUS ='0'
WHERE
T1.RSV_STATUS ='0'
ORDER BY
T1.LINE_ID DESC,
T1.SEAT_NO