Go to management studio open the clubstarter kit database and go to stored procedures and look for the above stored proc it has to be there.  And here is how you change it with the database open right click on it in the object browser and click on ALTER, make the above changes to the last line relating to Order By and execute it in management studio.  Hope this helps.