The STUDENT_GRADES table has these columns: 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   ORDER BY gpa DESC, semester_end ASC;
出自:Oracle认证

完成拼图验证

按住下方滑块,将拼图拖到缺口处后松开。

拼图背景,将小拼图拖到缺口处
向右拖动滑块