0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT TOP (10) u.DisplayName, q.NumPosts, q.AvgScore
FROM Users AS u
CROSS APPLY 
(
  SELECT NumPosts = COUNT(*), 
         AvgScore = AVG(Score*1.0)
  FROM Posts AS p
  WHERE p.PostTypeId = 2
    AND p.CreationDate >= '20220101'
    AND p.DeletionDate IS NULL
    AND p.OwnerUserId = u.Id
    AND EXISTS
    (
      SELECT 1 FROM PostTags pt 
      WHERE pt.PostId = p.ParentId
      AND pt.TagId = 
      (
        SELECT Id 
          FROM Tags 
          WHERE TagName = N'sql'
      )
    )
    GROUP BY p.OwnerUserId
    HAVING COUNT(*) >= 12 -- at least one a month
) AS q
ORDER BY q.NumPosts * q.AvgScore DESC; -- scientific!

fork query

edited feb 28

created dec 15 22 anonymous