TOP SONGS SQL CURRICULUM
Your Story Begins
You dream of becoming a famous singer, and to get your foot in the door, you've landed an internship at one of the world's top music labels: Stellar Sound Records.
As a junior data analyst, you'll use SQL to explore hit songs, uncover trends, and help the label make decisions—all while secretly hoping your name ends up on this list one day.

Your Learning Journey
SELECT, DISTINCT, FROM, ORDER BY
Aggregates and Group By
Since you have been doing such great work, you've been promoted from intern to Junior Analyst. You're not just pulling data—you're uncovering insights. Whether it's finding the most popular genres or tracking artist releases, your work is influencing what gets produced, promoted, and played. You're becoming a true data star behind the stars.
Practice: Putting It All Together
Data Transformations
Reporting with CASE and HAVING
Bonus · AI + data
AI Music Trend Challenge
Download trend data for Stellar Sound's new TikTok channel, work through simple prompt tips and four missions, then design a graphic with your top three picks.
Open challenge