Order by virker ikke

jeg kan ikke få nedenstående sql til at Order By Antal - så melder den fejl:

"SELECT Name, Count(IDrating) AS Antal, Avg(Rating) AS Rating  FROM rating, users  WHERE IDuser=userID  GROUP BY Name"

jeg vil have den som:

"SELECT Name, Count(IDrating) AS Antal, Avg(Rating) AS Rating  FROM rating, users  WHERE IDuser=userID  GROUP BY Name ORDER BY Antal" - men det virker ikke