Cities With at Least Three Students

Count the students in each city inside a CTE named per_city (columns city and students), then select city and students from it for the cities with three or more students. Sort by students descending, then city.

Expected result:

+-------------+----------+
| city        | students |
+-------------+----------+
| Toronto     |        8 |
| Ottawa      |        5 |
| Hamilton    |        4 |
| Mississauga |        4 |
| Kingston    |        3 |
| London      |        3 |
+-------------+----------+
6 rows

Hints3 available

Topics:

CTEs

Code Editor

Tab to indent (Esc then Tab to move on) · Ctrl+Enter to run · Ctrl+Space to expand shortcuts (sel, ins, desc)

Results

Run your SQL to see every statement's output here, then how it compares with the expected answer.

Not sure what is in a table? SHOW TABLES lists them and DESCRIBE students shows the columns — or open the database browser on the left.