Examine the structure of the STUDENTS table:You need to create a report of the 10 students who achieved the highest rank
Posted: Wed Jun 07, 2023 6:12 am
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;
- Examine The Str 1 (58.66 KiB) Viewed 167 times
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;