For the Maths final (subject 1), return class, name, score and class_rank (DENSE_RANK within the class, highest = 1).
15 rows with columns class, name, score, class_rank — first 3 shown:
| # | ||||
|---|---|---|---|---|
| 1 | 11A | Nisha | 89 | 1 |
| 2 | 11A | Lata | 76 | 2 |
| 3 | 11A | Om | 65 | 3 |
Run your code to see the output here.