Invalid query : select pID, first, last, sum(punts) as Punts, sum(puntyds) as PuntYds, sum(puntyds)/sum(punts) as PuntAvg , tID, city, tname from tecmoplayer, game_stats, tecmoteam where gslUID = 2 AND pID = gspUID AND tID = gsTeam AND gsSeason = 1983 AND gPlayoff = 1 AND pos = 9 AND punts > 0 group by pID order by PuntAvg desc