The business problem
A report must rank sales and compare each month with the previous one without collapsing detail.
What you will be able to do
Use OVER, PARTITION BY, ranking functions, LAG and running totals.
- Define a window
- Rank within a group
- Compare two periods
- Build a running total
What this micro-course does not promise yet
The content, exercises and laboratory are not accessible yet. This page describes a production goal, not a skill you can already practise on SQL.tn.
Prerequisites
- Aggregations, GROUP BY and CTEs
Project and practice
The planned structure contains 10 exercises and a mini-project. They will remain unavailable until they have been run and validated.