Project: Find the Top Performers
Explore how to combine SQL clauses like SELECT, WHERE, ORDER BY, and LIMIT to find the best performers in a data set. Understand how to use subqueries for filtering and extract meaningful summaries, preparing you to analyze real-world data confidently.
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, ...