Q&A for professional and enthusiast programmers
-- Enter Query Title -- Enter Query Description SELECT top 100 Id AS [User Link], (SELECT COUNT(*) FROM Posts WHERE Posts.OwnerUserId = Users.Id AND PostTypeId = 2 ) AS [Total Posts] FROM Users ORDER BY [Total Posts] DESC