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:

Unlicensed Attorney

An individual practicing law without the necessary legal authorization or license, which is illegal and subject to penalties.

Public Policy

Principles and standards considered to be in the public's interest by governing bodies and law.

Promissory Estoppel

A legal principle that prevents a party from reneging on a promise when the other party has reasonably relied on that promise to their detriment.

Administration of Justice

The process by which a legal system operates and enforces laws, ensuring fairness and resolving disputes.