WITH LeadData AS (
    SELECT 
        line_id,
        seat_no,
        rsv_status,
        LEAD(rsv_status, 1) OVER (PARTITION BY line_id ORDER BY seat_no) AS next_rsv_status,
        LEAD(rsv_status, 2) OVER (PARTITION BY line_id ORDER BY seat_no) AS next_next_rsv_status
    FROM
        seat_reserve
)
SELECT 
    line_id AS LINE,
    seat_no AS SEAT_F,
    seat_no + 2 AS SEAT_T
FROM
    LeadData
WHERE
    rsv_status = 0
    AND next_rsv_status = 0
    AND next_next_rsv_status = 0
ORDER BY
    line_id DESC,
    seat_no ASC;