Based on the table description and SQL shown, which query lists the states in the Students table and displays the number of students from each state? Students (StudentID, FirstName, LastName, Street, City, State, PostalCode)
A)SELECT State, COUNT(*) AS CountOfState FROM Students ORDER BY State;
B)SELECT State, COUNT(*) AS CountOfState FROM Students HAVING State;
C)SELECT State, COUNT(*) AS CountOfState FROM Students;
D)SELECT State, COUNT(*) AS CountOfState FROM Students GROUP BY State;

Question

Quizplus · Accepted Answer

Option D is correct because it groups the results by the State column and counts the number of students in each state, which is the requirement. The GROUP BY clause is necessary for aggregate functions like COUNT(*) to work correctly in this context.

Based on the Table Description and SQL Shown, Which Query