the studentgrades table has these columns studentid number 12 semesterend date..., SQL, Databases

Test
- Model Test
Index

Question:The STUDENT_GRADES table has these columns:

STUDENT_ID        NUMBER (12)
SEMESTER_END     DATE
GPA                  NUMBER (4)

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

/98

+ AnswerE

+ Report

Descriptive on SQL Ebook

Total Preview: 1259

Question:The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4) 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

E