Answers (by year)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Retrieve all answers of a user by year

History of Science and Math

Q&A for people interested in the history and origins of science and mathematics

SELECT
    a.Id AS [Post Link],
    a.Id,
    q.Title,
    a.CreationDate,
    a.Score,
    q.ViewCount AS [Views],
    CASE WHEN a.Id = q.AcceptedAnswerId THEN 1 ELSE 0 END AS Accepted,
    q.Tags
 FROM Posts a
 LEFT JOIN Posts q ON q.Id = a.ParentId
WHERE a.PostTypeId = 2 -- Answer
  AND a.OwnerUserId = ##UserId##
  AND Year(a.CreationDate) = ##Year##
ORDER BY a.CreationDate DESC

Enter Parameters

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