Which statement accomplish this?

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