SELECT Bowler.Team, Bowler.BowlerName,
Sum(Scores.GameOne) AS SOne, Sum(Scores.GameTwo) AS STwo,
Sum(Scores.GameThree) AS SThree,
Count(Scores.GameOne) AS COne, Count(SCores.GameTwo) AS CTwo,
Count(SCores.GameThree) AS CThree
FROM Bowler INNER JOIN Scores ON
Bowler.BowlerNumber = Scores.BowlerNumber
GROUP BY Bowler.Team, Bowler.BowlerName
ORDER BY Bowler.Team, Bowler.BowlerName;
Bowler Averages - Joined Data