Which SQL statement accomplishes this task?

Examine the structure of the STUDENTS table: 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. Which SQL statement accomplishes this task?

A.
SELECTstudent id, marks, ROWNUM “Rank” FROM(SELECT student_id, marks FROM
students ORDER BY marks) WHEREROWNUM <= 10 ANDfinish date BETWEEN
’01-JAN-99’ AND ’31-DEC-99’ ANDcourse_id = ‘INT_SQL’;

B.
SELECTstudent_id, marks, ROWNUM “Rank” FROM(SELECT student_id, marks
FROMstudents WHERE (finish_date BETWEEN ’01-JAN-99 AND ’31-DEC-99’ AND
course_id = ‘INT_SQL’ ORDER BY marks DESC) WHEREROWNUM <= 10 ;

C.
SELECTstudent_ id, marks, ROWNUM “Rank” FROMstudents WHEREROWNUM <= 10
ANDfinish_date BETWEEN ’01-JAN-99′ AND ’31-DEC-99 ANDcourse_id = ‘INT_SQL’
ORDER BYmarks DESC;

D.
SELECTstudent_id, marks, ROWID “Rank” FROMstudents WHEREROWID <= 10
ANDfinish_date BETWEEN ’01-JAN-99′ AND ’31-DEC-99′ ANDcourse_id = ‘INT_SQL’
ORDER BYmarks;

E.
SELECTstudent_id, marks, ROWNUM “Rank” FROM(SELECT student_id, marks
FROMstudents WHEREROWNUM <= 10 ANDfinish_date BETWEEN ’01-JAN-99′ AND
’31-DEC- 99′ ANDcourse_id = ‘INT_SQL’ ORDER BYmarks DESC);