SELECT
    T1.LINE_ID AS LINE
    , T1.SEAT_NO AS SEAT_F
    , MAX(T2.SEAT_NO) AS SEAT_T
FROM
    SEAT_RESERVE T1
    INNER JOIN SEAT_RESERVE T2 USING(LINE_ID)
WHERE
    T2.SEAT_NO BETWEEN T1.SEAT_NO AND T1.SEAT_NO + 2
GROUP BY 1,2
HAVING
    COUNT(NULLIF(T2.RSV_STATUS, '1')) = 3
ORDER BY 1 DESC, 2 ASC;