Row Number Basics — Solution & ExplanationProblems / Row Number Basics / EditorialApproachROW_NUMBER() is the simplest window function. It assigns a unique integer to each row within its partition.

Partition: Group by grade so numbering restarts for each grade.

Order: Sort by score descending so the top scorer gets 1.

Select & Order: Return the required columns ordered by grade then row number.

Unlike RANK(), ROW_NUMBER() never produces ties — even if two students have the same score, they get different row numbers.Hints

ROW_NUMBER() assigns a unique sequential integer to rows within a partition.

Use PARTITION BY grade to restart numbering for each grade.

ORDER BY score DESC ensures the highest scorer gets row number 1.

Solve Row Number Basics yourself →