SQL Analyst · CTE · ROW_NUMBER
Keep top two lines per region — support tickets · training scenario
Maintain the top two rows per region from a support ticket dataset designed to control level of detail and discrepancies. You must produce the result, check it on the source data and explain what it allows you to decide in this support ticket.
SQL Essentials
Unlock this exercise and continue the path.
Keep top two lines per region — support tickets · 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