I have a table which holds the results from game scores.
It has the following columns:
gameID : team1Score : team2Score
I'd like to produce output that calculates the following:
# Games played
# Wins
# Losses
# Ties
# Goals For
# Golas Against
Winning Percentage
I only know how to accomplish this using 7 seperate queries, but can I
get the same results with only one query?
Thanks!