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
number of employees = COUNT(*); whose title is IT Staff refers to title = 'IT Staff'; from each city refers to GROUP BY city;