试题详情
单项选择题 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;

  • 关注下方微信公众号，在线模考后查看

热门试题