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:

Re-recruiting

The process of engaging and hiring former employees or candidates who were previously considered for employment to leverage their skills and experiences.

Tight Labour Market

A market condition characterized by low unemployment and high job vacancies, giving employees more leverage to demand higher wages and better conditions.

Low Unemployment

Low unemployment refers to a condition where a low percentage of the workforce is without work but actively seeking employment, indicating a healthy economy.

High Unemployment

A situation where a large portion of the workforce is not engaged in employment, often measured by the unemployment rate.