试题详情
单项选择题 The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）

A、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

B、SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

C、SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

D、SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

E、SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

  • C

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

热门试题