Ok, I get it now. I'll have to create a new table to put this data into in order to join to it.

Something like this? Please check the numbers as I'm just doing an insert ignore using projrank < 101 to get the first available score for a rank < 101. Sometimes there is no exact 100 if multiple scores are the same as I group them together