How many employees who are IT staff are from each city?
SELECT count(*) ,  city FROM employees WHERE title  =  'IT Staff' GROUP BY city
count of employees who are IT staff from each city refers to COUNT(*) GROUP BY city; employees who are IT staff refers to title = 'IT Staff';