Students per city
Group students by city and keep only the cities with more than one student.
intermediateSQL
The task
Using the students table, show each city with more than one student, and how many students live there.
- One row per city: the city, then the number of students
- Only cities with more than 1 student
- Sorted by city name (A to Z)
Your output should be:
Phnom Penh 2 Siem Reap 2