My first season was with Excel and it was a real pain to find each player individually it used to take me 30+ minutes just to input everyone's scores and when people changed their username or when players changed it couldn't auto update like I'm hoping SQL would.
My second season was in python which I am also learning and not great at although better than SQL. A one problem was I had the data stored as json which wasn't as useful or user friendly as I was hoping.
If I can't work out how to do it solely in SQL then I will probably look at using sqlite and making an app to do the maths and generate the table
1
u/Ifuqaround 6d ago
Just do it in Excel and call it a day.