4

Please login or register to vote for this query.

(click on this box to dismiss)

How many of my comments have scores of 5 and higher, thus qualifying for the Pundit badge?

Q&A for those who study, teach, research and apply economics and econometrics

-- What's my Pundit badge progress?
-- How many of my comments have scores of 5 and higher, thus qualifying for the Pundit badge?

DECLARE @UserId INT = ##UserId##;

SELECT Score, Text, PostId AS [Post Link]
FROM Comments
WHERE UserId = @UserId
  AND Score >= 0
ORDER BY Score DESC, Text ASC;

fork query

edited may 28 12 Alex Lockwood

created nov 17 10 BoltClock