progress towards Guru badge

5

Please login or register to vote for this query.

(click on this box to dismiss)

shows your accepted answers and how close they are to earning the Guru badge (accepted answer and score of 40 or more)

Cognitive Sciences Meta

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

select 
    Answer.Id as [Post Link],
    Answer.Score,
    CAST(CONVERT(DECIMAL(5,2), Answer.Score * 2.5)  as VARCHAR(6)) + '%' as GuruProgress
from Posts as Question
LEFT JOIN Posts as Answer on Question.AcceptedAnswerId=Answer.Id
WHERE Question.PostTypeId=1 and Answer.OwnerUserId=##UserID:int## and Answer.CommunityOwnedDate is null
ORDER BY Answer.Score DESC

Enter Parameters

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