0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT TOP 1 U.Id, U.DisplayName, B.Name AS BadgeName
FROM Posts P
JOIN Users U ON P.OwnerUserId = U.Id
LEFT JOIN Badges B ON U.Id = B.UserId
WHERE YEAR(P.CreationDate) = 2023
ORDER BY P.ViewCount DESC;

fork query

edited apr 6

created apr 6 anonymous