MySQL Forums
Forum List  »  General

Calculate winning percentage per team.
Posted by: B R
Date: July 08, 2023 07:03PM

I have a 'games' table, in this table I have team1Id, team2Id, team1Score and team2Score.

team1Id & team2Id are INT and can be both ways, team1Id is the home team. So one row might have teamID 3 vs teamID 6 where another might be 6 vs 3.

What I want to do is calculate how many times each team has one a game.


TeamID 3: 5 wins
TeamID 6: 12 wins.

Any idea how I can do this?

Options: ReplyQuote

Written By
Calculate winning percentage per team.
July 08, 2023 07:03PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.