--COUNTを使う？
SELECT
    LINE_ID AS LINE,
    SEAT_NO AS SEAT_F,
    SEAT_NO AS SEAT_T
FROM
    SEAT_RESERVE
WHERE
    RSV_STATUS = '0'
ORDER BY
    LINE DESC,
    SEAT_F ASC;