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;