Which statement would be used to select all students with more than one grade?
A)WHERE COUNT(grade) 1
B)WHERE COUNT(grade)= 1
C)HAVING COUNT(grade) 1
D)HAVING COUNT(grade)= 1

Question

Which statement would be used to select all students with more than one grade?
A)WHERE COUNT(grade)> 1
B)WHERE COUNT(grade)>= 1
C)HAVING COUNT(grade)> 1
D)HAVING COUNT(grade)>= 1

Quizplus · Accepted Answer

The keyword HAVING is used to filter the results of an aggregation (COUNT in this case). In this query, we want to select all students who have more than one grade, so we need to filter by COUNT(grade) > 1. Therefore, the correct statement is HAVING COUNT(grade) > 1. Option A and B use the keyword WHERE, which filters rows based on a condition, but they do not work with aggregations. Option D uses >= instead of >, which would include students with only one grade.

Which Statement Would Be Used to Select All Students with More