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:

Charles's Law

A principle in physics that states the volume of a gas increases with increasing temperature, provided the pressure is constant.

Inspiratory Reserve Volume

The additional amount of air that can be inhaled after a normal inhalation, increasing lung volume.

Expiratory Reserve Volume

The additional amount of air that can be expelled from the lungs after a normal exhalation.