Messages Count

SELECT TOP 5 ChatId, COUNT(*) AS TotalMessages FROM Messages
WHERE Messages.Id < 90
GROUP BY ChatId
ORDER BY TotalMessages DESC, ChatId ASC