Get User Info (Total answers and Accepted Answers during a date range)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns the URL with the user's original inputted URL, the users reputation, number of answers posted, number of answers accepted. For https://www.codersclan.net/ticket/659

Web Applications

Q&A for power users of web applications

-- Get User(s) Info
-- Returns the URL with the user's original inputted URL, the users reputation, number of answers posted, number of answers accepted.
-- For https://www.codersclan.net/ticket/659

SELECT
  answer.OwnerUserId, Users.Reputation
FROM
  Posts answer
  LEFT OUTER JOIN Posts question ON question.AcceptedAnswerId = answer.id
  INNER JOIN Users ON answer.OwnerUserId = Users.id
WHERE
  answer.postTypeId = 2
  -- 2 means that post is an answer
GROUP BY 
  answer.OwnerUserId, 
  Users.Reputation

Enter Parameters

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