Largest number of positively scored answers in a single day by a single user

3

Please login or register to vote for this query.

(click on this box to dismiss)

Shows which users have posted the largest number of positively scored answers during one day. Also shows the day and the number of posts for each of these events.

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

SELECT TOP 100
  OwnerUserId AS [User Link],
  CAST(p.CreationDate AS DATE) AS [Day],
  COUNT(*) AS [Number of positively-scored posts]
FROM Posts p
WHERE
  p.PostTypeId = 2 -- answers only
  AND p.Score > 0 -- positively scored
  AND p.OwnerUserId <> '' -- don't worry about posts with no owner
  AND p.OwnerUserId IS NOT NULL -- don't worry about posts with no owner
GROUP BY p.OwnerUserId, CAST(p.CreationDate AS DATE)
ORDER BY COUNT(*) DESC

Enter Parameters

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