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)

Korean Language

Q&A for linguists, teachers and students of the Korean language

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 to meta site
loading Hold tight while we fetch your results