Project: Find the Top Performers
Discover how to apply SQL fundamentals by finding the top performers in a leaderboard. Learn to combine SELECT, WHERE, ORDER BY, LIMIT, and subqueries to extract and analyze data effectively. Gain hands-on experience with ranking and summary queries, preparing you for creating and managing your own tables next.
We'll cover the following...
We'll cover the following...
You’ve learned the fundamentals. Now it’s time to use them together in a real scenario.
Table leaderboard
Here’s the leaderboard of the top 3 scorers:
ID | Name | Score |
1 | Amina | 88 |
2 | Jonah | 72 |
3 | Layla | 95 |
4 | Marco | 78 |
Goal
You’ll aim to: ...