quote:

---

Originally posted by Page47

This is not really too difficult, but there are some core concepts you'll need to bone up on before you write this query. You'll need to fully understand the GROUP BY clause and how that allows use to use the SUM() aggregate. To do the Rank, you'll first need to define (in business rule terms) a ranking algorithm. Depending on what you come up with, you can probably use the RANK() or one of the other ranking functions.

Jay
to here knows when

EDIT: ...or someone else could do it for you ...

---

quote:

---

Originally posted by Page47

To each his own, I guess. My honeymoon period on this forum has long since past so, while I do enjoy "giving back" to the community in terms of advise and guidance, I'm way past the temptation to be the first to post a complete solution especially to such broad yet simple questions...sports or otherwise.

My only hope is that the OP takes the time to digest your code (I'm not going to bother, btw, so I also hope it is at least correct).

Jay
to here knows when

---

DECLARE @SeasonData TABLE (
  Season INT,
  MatchRound INT,
  Team1 CHAR(15),
  Team2 CHAR(15),
  GoalsTeam1 INT,
  GoalsTeam2 INT )

INSERT @SeasonData ( Season, MatchRound, Team1, Team2, GoalsTeam1, GoalsTeam2 )
SELECT 1, 1, 'ABC', 'DEF', 3, 2 UNION
SELECT 1, 1, 'GHI', 'JKL', 1, 1 UNION
SELECT 1, 2, 'DEF', 'GHI', 1, 0 UNION
SELECT 1, 2, 'JKL', 'ABC', 0, 2 UNION
SELECT 1, 3, 'ABC', 'GHI', 2, 2 UNION
SELECT 1, 3, 'DEF', 'JKL', 0, 0 UNION
SELECT 2, 1, 'ABC', 'DEF', 1, 2 UNION
SELECT 2, 1, 'GHI', 'JKL', 3, 1 UNION
SELECT 2, 2, 'DEF', 'GHI', 1, 1 UNION
SELECT 2, 2, 'JKL', 'ABC', 0, 2 UNION
SELECT 2, 3, 'ABC', 'GHI', 2, 4 UNION
SELECT 2, 3, 'DEF', 'JKL', 0, 1 UNION
SELECT 3, 1, 'ABC', 'Falcons', 5, 6 UNION
SELECT 3, 1, 'DEF', 'Gulls', 2, 2 UNION
SELECT 3, 1, 'GHI', 'Sparrows', 4, 7 UNION
SELECT 3, 1, 'JKL', 'Hawks', 3, 1 UNION
SELECT 3, 2, 'DEF', 'ABC', 4, 5 UNION
SELECT 3, 2, 'GHI', 'Falcons', 2, 1 UNION
SELECT 3, 2, 'JKL', 'Gulls', 8, 7 UNION
SELECT 3, 2, 'Hawks', 'Sparrows', 3, 2 UNION
SELECT 3, 3, 'GHI', 'DEF', 3, 2 UNION
SELECT 3, 3, 'JKL', 'ABC', 6, 1 UNION
SELECT 3, 3, 'Hawks', 'Falcons', 4, 4 UNION
SELECT 3, 3, 'Sparrows', 'Gulls', 2, 6 UNION
SELECT 3, 4, 'JKL', 'GHI', 1, 0 UNION
SELECT 3, 4, 'Hawks', 'DEF', 2, 4 UNION
SELECT 3, 4, 'Sparrows', 'ABC', 5, 1 UNION
SELECT 3, 4, 'Gulls', 'Falcons', 0, 0 UNION
SELECT 3, 5, 'Hawks', 'JKL', 3, 0 UNION
SELECT 3, 5, 'Sparrows', 'GHI', 4, 2 UNION
SELECT 3, 5, 'Gulls', 'DEF', 6, 1 UNION
SELECT 3, 5, 'Falcons', 'ABC', 1, 2 UNION
SELECT 3, 6, 'Sparrows', 'Hawks', 0, 3 UNION
SELECT 3, 6, 'Gulls', 'JKL', 1, 1 UNION
SELECT 3, 6, 'Falcons', 'GHI', 5, 1 UNION
SELECT 3, 6, 'ABC', 'DEF', 2, 2 UNION
SELECT 3, 7, 'Gulls', 'Sparrows', 4, 6 UNION
SELECT 3, 7, 'Falcons', 'Hawks', 3, 2 UNION
SELECT 3, 7, 'ABC', 'JKL', 3, 3 UNION
SELECT 3, 7, 'DEF', 'GHI', 0, 5 UNION
SELECT 3, 8, 'Falcons', 'Gulls', 2, 1 UNION
SELECT 3, 8, 'ABC', 'Sparrows', 1, 1 UNION
SELECT 3, 8, 'DEF', 'Hawks', 4, 2 UNION
SELECT 3, 8, 'GHI', 'JKL', 3, 1