Progress towards Commentator, Pundit

0

Please login or register to vote for this query.

(click on this box to dismiss)

10 comments needed for Commentator, 10 with score >= 5 for Pundit

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select TOP 10
    Q.Id as [Post Link],
    C.Score,
    CAST(CONVERT(INT, CAST(C.Score as float) * 20) as VARCHAR(5)) + '%' as PunditProgress
FROM Comments C
INNER JOIN Posts Q ON C.PostId = Q.Id
WHERE C.UserId=##UserID:int##
ORDER BY C.Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results