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 ;
student id, marks, ROWNUM “Rank”
E.
SELECT
FROM (SELECT student_id, marks
FROM students
ORDER BY marks)
WHEREROWNUM <= 10
finish date BETWEEN 01-JAN-99 AND 31-DEC-99
AND
course_id = ,,INT_SQL;
AND