SELECT
	S1.LINE_ID AS LINE
	,S1.SEAT_NO AS SEAT_F
	,S3.SEAT_NO AS SEAT_T
FROM
	SEAT_RESERVE S1
	INNER JOIN SEAT_RESERVE S2
		ON S1.LINE_ID = S2.LINE_ID
		AND S1.SEAT_NO + 1 = S2.SEAT_NO
	INNER JOIN SEAT_RESERVE S3
		ON S1.LINE_ID = S3.LINE_ID
		AND S1.SEAT_NO + 2 = S3.SEAT_NO
WHERE
	S1.RSV_STATUS = '0'
	AND S2.RSV_STATUS = '0'
	AND S3.RSV_STATUS = '0'
ORDER BY
	LINE DESC
	,SEAT_F ASC
;