Database: allergy_1
Question: How many students live in each city?
SQL:
SELECT city_code ,  count(*) FROM Student GROUP BY city_code