ORDER BY not working

[Simplicity]

Hi

Would anyone be able to look at the following statement and tell me why ORDER BY is not behaving as expected.

[code]SELECT RTeamName, SUM( RGamePld ) , SUM( RGameWon ) , SUM( RGameLost ) , SUM( RGameDraw ) , SUM( DLegFor ) , SUM( DLegAgainst ) , SUM( RPointsSum )
FROM LeagueTable
WHERE RDivision = 'A'
GROUP BY RTeamName
ORDER BY RPointsSum DESC
LIMIT 0 , 30[/code]

I've attached a screen dump of the data in the mySQL db for this query and a screen dump of the output. 

Any suggestions why this isn't sorting so that the team with two points is at the top of the table?

Many thanks
S.

[attachment deleted by admin]

[fenway]

You've not used an alias to reference your SUM() expression.