Sorting a Gallery by a Calculated Foreign Key Value

I have 2 tables Students and Classes. They have a one-to-many relationship. I am using a Foreign Key to calculate the total points for each class. I want to create a leaderboard that sorts those participating students by the calculated value. Obviously, these tables have more columns and data, but the attached image should clarify what I'm trying to accomplish. Any guidance of course is always greatly appreciated.

3 comments