Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language
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