[SOLVED] I'm not sure if this can be done.. but...

[woolyg]

Hi all,

 

I've got a table that logs points assigned to a player, and each player belongs to a league. Please see the image below for the layout:

 

 

What I want to do is select every player_id from the table, but order them according to the sum total of the points they have accumulated for league_id 1.

 

Can this be done? I've been banging my head off this for days...

 

Thanks,

Woolyg

[aschk]

So you want the TOTAL (sum) of ALL the points that each player has accumulated for league 1 ONLY.

SELECT player_id
      ,SUM(points) as 'total'
FROM <table name here>
WHERE league_id = 1
GROUP BY player_id

[woolyg]

That's right - The total of all points, per player, for league 1 only.

 

After the GROUP BY part, is it possible for me to ORDER BY 'total'?

 

Thanks,

WoolyG

[woolyg]

It is!

 

SELECT player_id
      ,SUM(points) as 'total'
FROM game_matches
WHERE league_id = 1
GROUP BY player_id
ORDER BY total DESC

 

Excellent - thank you so much for your input aschk.

 

Solved.