SELECT COUNT(MessageID) AS Anzahl, Username FROM User
WHERE User.UserID = Nachricht.UserID
GROUP BY Username
ORDER BY Anzahl DESC