inner joins and ordering 1

[peter11]

<cfquery name="goals" datasource ="paperfree">
select sproster.lastname, sproster.firstname , sum(spplayerstats.goal) as goaltot from sproster inner join spplayerstats on sproster.playerID = spplayerstats.playerID
group by sproster.lastname, sproster.firstname
</cfquery>

How would I order the above query in descending order of the sum of goals (goaltot)?

 

[TruthInSatire]

<cfquery name="goals" datasource ="paperfree">
select sproster.lastname, sproster.firstname , sum(spplayerstats.goal) as goaltot from sproster inner join spplayerstats on sproster.playerID = spplayerstats.playerID
group by sproster.lastname, sproster.firstname
order by sum(spplayerstats.goal) desc
</cfquery>


Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1959-2001)