Hey all,
I'm trying to write a query in SQL that will do a bunch of calculations all at once. The main part of it is that I have to calculate percentages and I don't know how. Here's what I need. I have a database that keeps track of peoples scores and standings in an ongoing "ranking" system. My table has challenge, game, match, player. For each player, I need to figure out things like winning percentages for matches, winning percentages for all games played, and the average winning margin. I'm not sure how to get all that out, in a query, I've never had to "calculate" anything while running a query. I especially do not know how to do the percent part. Any help would be greatly appreciated. I'm lost...
Thanks again
wavo
I'm trying to write a query in SQL that will do a bunch of calculations all at once. The main part of it is that I have to calculate percentages and I don't know how. Here's what I need. I have a database that keeps track of peoples scores and standings in an ongoing "ranking" system. My table has challenge, game, match, player. For each player, I need to figure out things like winning percentages for matches, winning percentages for all games played, and the average winning margin. I'm not sure how to get all that out, in a query, I've never had to "calculate" anything while running a query. I especially do not know how to do the percent part. Any help would be greatly appreciated. I'm lost...
Thanks again
wavo
