The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) 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?()
- ASELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
- BSELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;
- CSELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;
- DSELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;
- ESELECT student_id, semester_end, gpa FROM student_grade