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.
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
WHERE (finish_date BETWEEN ’01-JAN-99 AND ’31-DEC-99′
AND course_id = `INT_SQL’
ORDER BY marks DESC)
WHERE ROWNUM <= 10 ;
E.
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’;