Q&A for people looking to bypass life's everyday problems with simple tricks
WITH Has100Answers AS (SELECT TOP 10 OwnerUserId, COUNT(Id) AS NumPosts FROM Posts WHERE PostTypeId = 2 AND OwnerUserId IS NOT NULL GROUP BY OwnerUserId HAVING COUNT(Id) >= 100) SELECT TOP 10 Id AS [User Link], CreationDate, DisplayName FROM Users WHERE Id IN (SELECT TOP 10 OwnerUserId FROM Has100Answers) ORDER BY CreationDate DESC