Databases · Junior · Question 71 of 75

How do you get the 5 cities with the most users?

1SELECT TOP 5 city FROM users;
2SELECT city FROM users ORDER BY city LIMIT 5;
✓Correct answer: SELECT city, COUNT(*) AS n FROM users GROUP BY city ORDER BY n DESC LIMIT 5;

Explanation

Group, count, sort by the count and limit. ORDER BY can use the alias n because it runs after SELECT.

Further reading

Test yourself

Take the Databases · Junior quiz: questions and options are shuffled, and you get a review of your mistakes at the end.