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?

Question

Options

• ASELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
• BSELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
• CSELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY
• DSELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM
• ESELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT

• A
  13% (2)
• B
  7% (1)
• C
  80% (12)

Explanation

For highest gpa value MAX function is needed, for result with per semester GROUP BY clause is

No community discussion yet for this question.