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.
Q&A about the site for Joomla! administrators, users, developers and designers
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