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 gpa DESC,
semester_end ASC;

B.
SELECT student_id,semester_end,gpa FROM student_grades ORDER BY
semester_end,gpa DESC

C.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,
semester_end DESC;

D.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end, gpa ASC

E.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end DESC, gpa DESC;

F.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,
semester_end ASC;