> > >

ASP.NET With 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

ASP.NET With SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it

More ASP.NET With SQL Server MCQ Questions

ASP.NET With SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it