2023 challenges by users with no challenges before 2023

0

Please login or register to vote for this query.

(click on this box to dismiss)

For judging the https://codegolf.meta.stackexchange.com/questions/25424/best-of-cgcc-2022-call-for-categories

Stack Overflow

Q&A for professional and enthusiast programmers

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

Enter Parameters

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