2020 answers by users with no answers before 2020

0

Please login or register to vote for this query.

(click on this box to dismiss)

Code Golf and Coding Challenges

Q&A for programming puzzle enthusiasts and code golfers

SELECT Q.Title, A.Id, A.Score, U.DisplayName
  FROM
    (Posts A JOIN Users U
     ON A.OwnerUserId = U.Id)
    JOIN Posts Q
    ON A.ParentId = Q.Id
    WHERE year(A.CreationDate) = 2016
    AND A.PostTypeId = 2 -- Post is answer
    AND NOT EXISTS (SELECT *
                    FROM Posts A2
                    WHERE A2.OwnerUserId = U.Id
                    AND year(A2.CreationDate) < 2016
                    AND A2.PostTypeId = 2)
  ORDER BY A.Score DESC

Enter Parameters

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