SELECT
A.LINE_ID AS LINE,
A.SEAT_NO AS SEAT_F,
--A.SEAT_NO +1 AS NEXT_SEAT_NO,
A.SEAT_NO +2 AS SEAT_T
--A.RSV_STATUS,
--B.NEXT_RSV_STATUS,
--C.NEXTNEXT_RSV_STATUS
FROM
SEAT_RESERVE A
LEFT JOIN
(
	SELECT
	LINE_ID,
	SEAT_NO,
	RSV_STATUS AS NEXT_RSV_STATUS
	FROM
	SEAT_RESERVE
) B
ON A.LINE_ID = B.LINE_ID
AND A.SEAT_NO +1 = B.SEAT_NO
LEFT JOIN
(
	SELECT
	LINE_ID,
	SEAT_NO,
	RSV_STATUS AS NEXTNEXT_RSV_STATUS
	FROM
	SEAT_RESERVE
) C
ON A.LINE_ID = C.LINE_ID
AND A.SEAT_NO +2 = C.SEAT_NO
WHERE A.RSV_STATUS = '0' AND B.NEXT_RSV_STATUS = '0' AND C.NEXTNEXT_RSV_STATUS = '0'
ORDER BY A.LINE_ID DESC
 ,A.SEAT_NO;