Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12)
SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the
students’ grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order
requested by the registrar?

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12)
SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the
students’ grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order
requested by the registrar?

A.
SELECT student_id, gpa FROM student_grades ORDER BY gpa;

B.
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;

C.
SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

D.
SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;

E.
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;

F.
SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;



Leave a Reply 1

Your email address will not be published. Required fields are marked *


helion

helion

Answer is: C