--【問題9】
SELECT
	A.LINE_ID AS LINE
,	A.SEAT_NO AS SEAT_F
,	C.SEAT_NO AS SEAT_T
FROM
	SEAT_RESERVE A
LEFT OUTER JOIN
	SEAT_RESERVE B
ON
	A.LINE_ID = B.LINE_ID
AND	A.SEAT_NO + 1 = B.SEAT_NO
LEFT OUTER JOIN
	SEAT_RESERVE C
ON
	B.LINE_ID = C.LINE_ID
AND	B.SEAT_NO + 1 = C.SEAT_NO
WHERE
	A.RSV_STATUS = '0'
AND	B.RSV_STATUS = '0'
AND	C.RSV_STATUS = '0'
ORDER BY
	A.LINE_ID DESC
,	A.SEAT_NO