0

Please login or register to vote for this query.

(click on this box to dismiss)

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],
CASE
WHEN Users.Reputation > 1000 THEN (SELECT COUNT(Score)
FROM Posts
WHERE Posts.OwnerUserId = Users.Id
AND PostTypeId = 2
) 
ELSE 1
END AS [Total Score]
FROM Users
ORDER BY [Total Posts] DESC

fork query

created sep 5 10 Peter Ajtai