How many of my comments have scores of 5 and higher, thus qualifying for the Pundit badge?
Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
-- 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 ORDER BY Score DESC, Text ASC;