Invalid query : select pID, first, last, sum(gsPunts) as Punts, sum(gsPuntYards) as PuntYds, sum(gsPuntYards)/sum(gsPunts) as PuntAvg from tecmoplayer, game_stats, tecmoteam where gslUID = 1 AND pID = gspUID AND tID = gsTeam AND gPlayoff = 0 AND gsfranchise = AND pos = 9 AND gsPunts > 0 group by pID order by last asc