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

Constructed Languages Meta

Q&A about the site for designers and users of artificial or invented languages, consciously developed instead of having developed naturally

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