yeah you were right. it is straight forward.

Here's the away averages query.

SELECT Team.team, SUM(AFLPlayerStats.kicks) / COUNT(DISTINCT AFLGame.aflgame_id) AS Kicks, SUM(AFLPlayerStats.marks)

...

Thanks for that.

My first post wasn't very clear but what if I just wanted the home or away team averages. I can't wrap my head around how to do such...