GROUP BY Clause Example

This example creates a list of unique job titles and the number of employees with each title.

SELECT Title, Count([Title]) AS Tally FROM Employees GROUP BY Title;

For each unique job title, this example calculates the number of employees in Washington who have that title.

SELECT Title, Count(Title) AS Tally FROM Employees WHERE Region = 'WA' 
GROUP BY Title;