> > >

Microsoft SQL Server MCQs

The STUDENT_GRADES table has these columns:

STUDENT_ID        INT
SEMESTER_END        DATETIME
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 WHERE gpa IS NOT NULL

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

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

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

Answer

Correct Answer: SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end

Explanation:

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

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it