Invalid query : select tID, city, tname, sum(gsPassYards) as PassYards, sum(gsRushYards) as RushYards, sum(gsPassYards)+sum(gsRushYards) as TotalYards, (sum(gsPassYards)+sum(gsRushYards))/COUNT(DISTINCT gsgUID) as avgyds from tecmoplayer, game_stats, tecmoteam where gslUID = 1 AND pID = gspUID AND tID = gsTeam AND gPlayoff = 0 AND gsfranchise = AND tID = gsTeam group by tID order by city asc