Based on the Table Description and SQL Shown, Which Query

Multiple Choice

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;