The STUDENT_GRADES table has these columns: The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes 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 ASC, gpa ASC;
- C SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end, gpa DESC;
- 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