Hi,
There is a sample of my table:
Game # winningTeam losingTeam winScore lostScore
1 Tigers Flames 4 3
2 Canucks Tiger 5 2
3 Pens Canucks 6 2
4 Tigers Av's 2 1
My question is simple. I would like to request the sum of winScore and the sum of lostScore for each team.
I can't group by winningTeam because the score of the winScore when the team is the losingTeam is not in the sum. Clear?
It may seem easy (maybe it is)but I'm a little rusted and with SQL and would like some help.
thanks
There is a sample of my table:
Game # winningTeam losingTeam winScore lostScore
1 Tigers Flames 4 3
2 Canucks Tiger 5 2
3 Pens Canucks 6 2
4 Tigers Av's 2 1
My question is simple. I would like to request the sum of winScore and the sum of lostScore for each team.
I can't group by winningTeam because the score of the winScore when the team is the losingTeam is not in the sum. Clear?
It may seem easy (maybe it is)but I'm a little rusted and with SQL and would like some help.
thanks