I have slightly different results from the provided solution as well... checked my logic multiple times but couldn't figure out what caused the variance. Although the top 3 teams seem to align with the provided solution, and variance does not apply to all the teams. Well will have to check back next week for the solution... For now, here's mine.
Nice but of classic data prep! Check out the video solution: https://www.youtube.com/watch?v=U1Tn0igCBk4&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=17&t=0s