2016 questions by users with no questions before 2016

0

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Puzzles and Code Golf

Q&A for programming puzzle enthusiasts and code golfers

SELECT P.Id AS [Post Link], P.Score, U.DisplayName
  FROM Posts P JOIN Users U
    ON P.OwnerUserId = U.Id
    WHERE year(P.CreationDate) = 2016
    AND P.PostTypeId = 1 -- Post is question
    AND NOT EXISTS (SELECT *
                    FROM Posts P2
                    WHERE P2.OwnerUserId = U.Id
                    AND year(P2.CreationDate) < 2016
                    AND P2.PostTypeId = 1)
  ORDER BY P.Score DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results