Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


boostr.in questions - Question:The STUDENT_GRADES table has the following columns:STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4, 3) Which of the following statements 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;

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes
12 views



Related Hot Questions



Government Jobs Opening


...