Based on the Table Description and SQL Shown, Which Query

question 16

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;

---

Definitions:

Former Employer

A previous organization or individual for whom one has worked.

Market Product

A product or service offered for sale within a specific market.

Fair Use

A legal doctrine that permits limited use of copyrighted material without requiring permission, typically for purposes such as criticism, commentary, teaching, or research.

Copyrighted Material

Works like literature, music, and art that are legally protected, prohibiting unauthorized use or duplication.