Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
CAREFULLY CONSIDER THE RELATIONSHIP BETWEEN THE TABLES
Make sure you're relating the tables to each other correctly :)
the differences between RANK, DENSE_RANK and ROW_NUMBER are how they handle dups.
Rank- Unique Rank for each row, dupes skip the next rank. Eg: 1, 2, 3, 3, 5. Rank 4 is skipped.
Dense Rank- Unique Rank for each row but Dupes aren't skipped. Eg, 1, 2, 3, 3, 4, 5. Rank 4 isn't skipped, it comes after the dupes.
ROW_NUMBER- Unique rank for each row regardless of dupes. Every row gets ranked in order, duplicates are ignored. Eg, 1, 2, 3, 4, 5, 6.
Pay keen attention to the datatypes friends :)
This comment is hidden because it contains spoiler information about the solution