Войти
  • 165Просмотров
  • 2 месяца назадОпубликованоDataSync Academy

SQL Beginner Portfolio Project | Top Revenue Category Q3 2025 | SQL Analytics Project

SQL Beginner Portfolio Project — Top Revenue Category Q3 2025 In this video, we solve a medium-level SQL analytics problem: identifying which product category brought the highest revenue in the third quarter of 2025 (July to September). This is a strong use-case in business analytics and a fantastic SQL interview-style question. You’ll learn: • How to filter data using date ranges (WHERE … BETWEEN) • How to join orders, orderdetails, and products tables • How to aggregate revenue (quantity × price) by category • How to sort and pick the top result with ORDER BY and LIMIT • Best practices for writing clean SQL queries and edge-case tips This tutorial is perfect if you’re building a **SQL portfolio**, preparing for **SQL interviews**, or strengthening your **data analytics skills**. ✅ The source code and dataset are in the description for you to practice. 🔥 If you like this video, please subscribe, like, and leave a comment. Source Code & Dataset: I’ll keep updating it as new queries are added to the playlist.