Challenge: Find the Top Performers
Apply filters, aggregates, and sorting to answer questions.
We'll cover the following...
You’ve learned the fundamentals. Now it’s time to use them together in a real scenario.
Sample 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
,WHERE
,ORDER BY
, ...