This example selects the job titles assigned to more than one employee in the Washington region.
SELECT Title, Count(Title) as Total FROM Employees WHERE Region = 'WA' GROUP BY Title HAVING Count(Title) > 1;