progress towards Guru badge

1

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)

Stack Overflow

Q&A for programmers

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
:records returned in :time ms:cached