SELECT
    LINE_ID AS LINE
,   MIN(SEAT_NO) AS SEAT_F
,   MAX(SEAT_NO) AS SEAT_T
FROM
    SEAT_RESERVE
WHERE
    RSV_STATUS = '0'
GROUP BY
    LINE
ORDER BY
    LINE DESC
,   SEAT_F