Table schema:
CREATE TABLE employee (city VARCHAR)

Question: What is the number of employees from each city?
SQL: SELECT COUNT(*), city FROM employee GROUP BY city