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_ID
ORDER BY 
LINE_ID DESC,
SEAT_NO ASC;