Which statement accomplish this?

The STUDENT_GRADES table has these columns:
STUDENT_IDNUMBER(12)
SEMESTER_ENDDATE
GPANUMBER(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