Project: Find the Top Performers
Explore how to combine essential SQL commands to identify top performers from a leaderboard. Learn to sort, filter, limit results, and apply subqueries to gain meaningful data insights. This lesson strengthens your ability to write precise queries and prepare for creating and managing your own tables.
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:
Combine
SELECT, ...