Sortering i Sub-query

Hur gör jag för att sortera efter summan av score distinct per player?

Datat ligger såhär:
player : score : roundid : course
1 : 3 : 1 : 1
1 : 2 : 1 : 1
2 : 4 : 1 : 1
2 : 2 : 1 : 1
4 : 3 : 1 : 1
4 : 1 : 1 : 1

Har kommit såhär långt, men fastar på en where-sats i mitt sub-query.

select distinct player from stats where roundid = 1 and course = 1 order by (select sum( score ) from stats ) asc

Mvh, Vide

select player from
(select player,sum(score) as score
    from stats
  where roundid = 1
  group by player ) dt
order by score

Tackar!! :D