Query failed => SELECT ID_Equipe, ID_Joueur, Club, Poste, Nom, Prenom, SUM(MJ) AS NbMatch, SUM(B) AS Buts, SUM( A ) AS Ass, SUM(PTS) AS Pts, SUM(PEM) AS Pen, AVG(B) AS ButsMJ, AVG(A) AS AssMJ, AVG(PTS) AS PtsMJ, AVG(PEM) AS PenMJ
FROM Compteurs
WHERE ID_Saison=42 AND ID_Division = 89 AND ID_Equipe = 6678 GROUP BY ID_Joueur ORDER BY Buts DESC, ButsMJ DESC, Pts DESC, Ass DESC, Pem