Who's asking/answering the most questions on U.S. holidays?! (And why? ... just kidding, we know why...)
Q&A for meta-discussion of the Stack Exchange family of Q&A websites
-- Holiday Work Horse
-- Who's asking/answering the most questions on U.S. holidays?! (And why? ... just kidding, we know why...)
DECLARE @year int = ##Year##
u.DisplayName as 'User Name'
,count(p.Title)+count(c.Id) as 'Number of Questions/Answers/Comments'
,(u.Reputation/(count(p.title)+count(c.Id))) as 'Reputation'
INNER JOIN posts p on p.OwnerUserId = u.id
INNER JOIN comments c on c.UserId = u.id
AND (p.PostTypeId IN (1,2))
AND p.OwnerUserId IS NOT NULL
AND u.Reputation > 250
-- AND u.DisplayName = 'iight'
(Month(p.CreationDate) = 12 AND Day(p.CreationDate) = 25)/* Xmas */
(Month(p.CreationDate) = 7 AND Day(p.CreationDate) = 4)/* July 4 */
AND year(p.CreationDate) = @year
'Number of Questions/Answers/Comments' DESC