SELECT
	T2.LINE AS LINE
	,T2.SEAT_F AS SEAT_F
	,T2.SEAT_T AS SEAT_T
FROM (
	SELECT
		T1.LINE_ID AS LINE
		,T1.SEAT_NO AS SEAT_F
		,T1.SEAT_NO + 2 AS SEAT_T
		,(
			SELECT 
				TF.RSV_STATUS
			FROM SEAT_RESERVE TF
			WHERE
				TF.LINE_ID = T1.LINE_ID
			AND	TF.SEAT_NO = T1.SEAT_NO
		) AS RSV_F
		,(
			SELECT 
				TF.RSV_STATUS
			FROM SEAT_RESERVE TF
			WHERE
				TF.LINE_ID = T1.LINE_ID
			AND	TF.SEAT_NO = T1.SEAT_NO+1
		) AS RSV_S
		,(
			SELECT 
				TF.RSV_STATUS
			FROM SEAT_RESERVE TF
			WHERE
				TF.LINE_ID = T1.LINE_ID
			AND	TF.SEAT_NO = T1.SEAT_NO+2
		) AS RSV_T
	FROM SEAT_RESERVE T1
	WHERE T1.SEAT_NO <= 13
) T2
WHERE
	T2.RSV_F = 0
AND	T2.RSV_S = 0
AND	T2.RSV_T = 0
ORDER BY
	T2.LINE DESC
	,T2.SEAT_F ASC