Q&A for SharePoint enthusiasts
SELECT UserId FROM Comments GROUP BY UserId HAVING COUNT(*) = ( SELECT MAX(Cnt) FROM (SELECT COUNT(*) AS Cnt FROM Comments GROUP BY UserId) AS SubQuery );