I have a friend that wants me to design them a priority system for a class. I am struggling with how to do the math and then add it to the sql.
Here is what she is looking for. She wants to compare a students GPA and how far they travel in order to prioritize class sign ups. Here is the issue. The comparison needs to take into consideration GPA with more weight than distance. i.e. Someone with a 4.0 GPA that travels 5 miles should get more priority than someone with a 2.0 GPA that travels 200 miles.
Basically she is a nursing student. 75% of the students commute to the university from 1-2 hours away. The schedules are very sporadic and there is no preference for students who commute. She made a proposal to her professors on this little project so she asked me to write the program. So, it needs to make sure that people who have the highest GPA get 1st dibs on the "good" schedule but weigh in the distance of the commute.