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;