I was searching for help to figure out Goals Scored ranking for my hockey database to figure out where a team ranks in the league for the category of Goals Scored. I received some great feedback in the answers here text and had it working great.

The screenshot shows the table i am using. I am identifying each student using learner_id and i would like to be calculating the sum of total scores for each student using the total field. Based on the sum of scores, i would like to evaluate the student positions based on highest sum of scores.
Image of scores_table