单项选择题The STUDENT_GRADES table has these columns:STUDENT_ID NUMBER(12)SEMESTER_END DATEGPA 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?()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
A.SELECT
B.SELECT
C.SELECT
D.SELECT
E.SELECT