How close am I to the Self-learner badge? All self-answers to my own questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

For each answer to my own questions I have question score and answer score. To get the Self-learner badge I need at least 3 votes on an answer among these.

Engineering

Q&A for professionals and students of engineering

SELECT 
    q.Id as QuestionId,
    a.Id as AnswerId,
    q.Id as [Post Link],
    q.Score as QuestionScore,
    a.Score as MyAnswerScore
FROM
    Posts q
  INNER JOIN 
    Posts a ON q.AcceptedAnswerId = a.Id
  INNER JOIN
    Users ON Users.Id = q.OwnerUserId
WHERE 
    q.OwnerUserId = a.OwnerUserId and Users.Id = ##UserId##

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results