Day 8 SQL Challenge | Top Customers by 2024 Sales | 30‑Day SQL Project Series

Welcome to Day 8 of the 30‑Day SQL Project‑Based Challenge for Data Professionals!
In today’s lesson, we walk through a highly practical SQL task: identifying the top customers by total sales in 2024. This exercise reinforces essential analytical SQL skills used daily by Data Analysts, BI Developers, and Data Engineers.
This challenge teaches you how to combine multiple tables, cleanly aggregate financial metrics, and extract business‑ready insights—exactly the kind of SQL logic used in reporting, dashboarding, and stakeholder analytics.

🔹 What You Will Learn in This Lesson

- How to combine multiple tables using LEFT JOINs
- How to filter by year using
- How to calculate total customer sales
- How to group results using a clean GROUP BY strategy
- How to produce ranked outputs
- How to limit results to a top‑N list

📌 Follow along with the challenge:
https://github.com/dspacademy/30-Day-SQL-Challenge

If you’re leveling up your SQL skills as a Data Professional, be sure to like, comment, and subscribe for daily SQL insights.

Видео Day 8 SQL Challenge | Top Customers by 2024 Sales | 30‑Day SQL Project Series канала Data Solution Platform