The STUDENT_GRADES table has these columns:
STUDENT_ID. NUMBER(12)
SEMESTER_END. DATE
GPA. NUMBER(4, 3)
The registrar has asked for a report on the average grade point average (GPA), sorted from the highest grade point average to each semester, starting from the earliest date.
Which statement accomplish this?
A. SELECT student_id, semester_end, gpa
FROM student_grades
ORDER BY semester_end DESC, gpa DESC;
B. SELECT student_id, semester_end, gpa
FROM student_grades
ORDER BY semester_end, gpa ASC
C. SELECT student_id, semester_end, gpa
FROM student_grades
ORDER BY gpa DESC, semester_end ASC;
D. SELECT student_id, semester_end, gpa
FROM student_grades
ORDER BY gpa DESC, semester_end DESC;
E. SELECT student_id, semester_end, gpa
FROM student_grades
ORDER BY gpa DESC, semester_end ASC;
F. SELECT student_id, semester_end, gpa
FROM student_grades
ORDER BY semester_end, gpa DESC
|
Download Printable PDF. VALID exam to help you PASS. |
 |