> > >

MySQL MCQs

The STUDENT_GRADES table has these columns:
STUDENT_ID INT
SEMESTER_END DATE
GPA FLOAT
Which of the following statements finds the highest Grade Point Average (GPA) per semester?

SELECT MAX(GPA) FROM STUDENT_GRADES WHERE GPA IS NOT NULL

SELECT GPA FROM STUDENT_GRADES GROUP BY SEMESTER_END

SELECT MAX(GPA) FROM STUDENT_GRADES GROUP BY SEMESTER_END

SELECT TOP 1 GPA FROM STUDENT_GRADES GROUP BY SEMESTER_END

None of the above

Answer

Correct Answer: SELECT MAX(GPA) FROM STUDENT_GRADES GROUP BY SEMESTER_END

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it