0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT TOP 1 *

FROM
    Users
JOIN
    Posts AS Answers ON Users.Id = Answers.OwnerUserId 
WHERE
    Answers.PostTypeId = 2 -- Answers only
    AND Answers.CreationDate >= DATEADD(year, -1, GETDATE()) -- Within the last year

view current version

edited feb 22

created feb 22 anonymous