Examine the structure of the STUDENTS table:<br /> STUDENT_ID NUMBER NOT NULL, Primary Key<br /> STUDENT_NAME VARCHAR2(30)<br /> COURSE_ID VARCHAR2(10) NOT NULL<br /> MARKS NUMBER<br /> START_DATE DATE<br /> FINISH_DATE DATE<br /> You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.<br /> Which SQL statement accomplishes this task?（）

A、SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC;

B、SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks;

C、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC);

D、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks DESC) WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id ='INT _ SQL';