Rough estimation of consistent answerers on SO in 2022

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans Meta

Q&A about the site for music historians, critics, and fans

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 >= '20230101'
    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!

Enter Parameters

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