Student id, id in all the subjects, subjects scores, students in the class
Ask each student's total score and ranking in class's and grade's

Thought is the student first, sum (score) and then according to the results in the rank () partition by
Do you have more simple calculation method