SELECT count(*) ,  city FROM employee GROUP BY city
Count the number of employees for each city.
SELECT count ( * ) , city FROM employee GROUP BY city
select count ( * ) , city from employee group by city
Count the number of employees for each city .