Q&A for professional and enthusiast programmers
SELECT Count(*) OVER (PARTITION BY UserID) TimePerUser, UserID [User Link], CASE WHEN p.closedDate IS NULL THEN 0 ELSE 1 END IsClosed , Reputation, Text, p.id [Post Link], p.tags FROM COMMENTS c INNER JOIN posts p ON c.PostID = p.ID LEFT JOIN users U ON c.UserID = u.id WHERE TEXT LIKE '%/meta.stackoverflow.com/questions/128548/%' ORDER BY Count(*) OVER (PARTITION BY UserID) DESC