SELECT count(*) ,  city FROM employees WHERE title  =  'IT Staff' GROUP BY city
Find the number of employees whose title is IT Staff from each city?
SELECT count ( * ) , city FROM employees WHERE title = 'IT Staff ' GROUP BY city
select count ( * ) , city from employees where title = value group by city
Find the number of employees whose title is IT Staff from each city ?