| Title | Topics | Action | |||
|---|---|---|---|---|---|
| 50 | Number the Students by GPAGive every student with a known `gpa` a position with `ROW_NUMBER()`: return `rn... | easy | ○ Not Started | Window Functions | Solve |
| 51 | Rank Versus Dense RankShow how the two ranking functions differ on tied grade point averages. For ever... | easy | ○ Not Started | Window Functions | Solve |
| 52 | Running Total of Course FeesList the courses in `id` order with a running total of their fees: return `id`, ... | easy | ○ Not Started | Window Functions | Solve |
| 53 | Rank Students Within Their CityRank the students inside their own `city` rather than across the whole college: ... | medium | ○ Not Started | Window Functions | Solve |
| 54 | Each Salary and the Next Lower OneList the instructors from the best paid down: return `first_name`, `last_name`, ... | medium | ○ Not Started | Window Functions | Solve |
| 55 | Quartiles and Distance From the AverageFor every student with a known `gpa`, return `first_name`, `last_name`, `gpa`, `... | medium | ○ Not Started | Window Functions | Solve |
| 56 | Top Two Students in Each MajorFind the two students with the highest `gpa` in every major. In a CTE named `ran... | hard | ○ Not Started | Window Functions | Solve |
| 57 | Each Department's Share of the StudentsReport how the student body splits across majors: return `department` (the depar... | hard | ○ Not Started | Window Functions | Solve |