SQL Practice Project: Sales Analysis

Build a practical sales analysis project in SQL using JOIN, GROUP BY, CASE, CTEs, and window functions. ## Lesson objectives In this lesson, we will apply the SQL topics we have learned in a practical project. In the previous lessons, we learned separate SQL topics: aggregate functions subqueries window functions common operators date and time CTE In this lesson, we will combine these topics in a real analysis workflow. The goal is not only to learn SQL syntax. The goal is to understand how to answer real business questions with SQL. We will work with sales data.