SELECT name, SUM(Points)/COUNT(game_id) AS P, 100*SUM(FGPercent)/COUNT(game_id) AS FGP, 100*SUM(threeP)/COUNT(game_id) AS TP, 100*SUM(FTPercent)/COUNT(game_id) AS FT, SUM(rebounds)/COUNT(game_id) AS REB, SUM(block)/COUNT(game_id) AS B, SUM(steal)/COUNT(game_id) AS S, SUM(assist)/COUNT(game_id) AS A
FROM stats
WHERE team= ' $team'
GROUP BY points
ORDER BY p DESC
Now it wont add up all stats for players with same name because of a column game_id is there anway to ignore this column ?
