SQL Analyst · ROW_NUMBER · PARTITION BY
Rank results in each region — national expeditions training scenario
Rank results in each region using a national shipment dataset designed to control level of detail and variances. You must produce the result, check it on the source data and explain what it allows you to decide in this national expeditions.
SQL Essentials
Unlock this exercise and continue the path.
Rank results in each region — national expeditions training scenario is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge