Invalid query : select pUID, first, last, ttAbrev, ttTecmoOrder, sum(gsRushes) as Rushes, sum(gsRushYards) as RushYards, sum(gsRushYards)/sum(gsRushes) as AvgRush, sum(gsRushTDs) as RushTDs , tttID, ptttID, gsWeek from player_atts, tecmoplayer, standings, game_stats where pUID = pID AND ttlUID = plUID AND pttUID = ttTecmoOrder AND tttID = gsTeam AND pUID = gspUID AND ttlUID = 1 AND gslUID = ttlUID AND plUID = ttlUID AND gsSeason = 2024 AND ttsUID = gsSeason AND psUID = ttsUID AND gsWeek = AND (pPos = 0 OR pPos = 1 OR pPos = 2 OR pPos = 3) AND gsRushes > 0 group by gspUID, gsTeam order by RushYards desc, AvgRush desc, RushTDs desc