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/commenting the most -- on typical U.S. holidays?! And why? (just kidding) SELECT 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' FROM users u INNER JOIN posts p on p.OwnerUserId = u.id INNER JOIN comments c on c.UserId = u.id WHERE 1=1 AND (p.PostTypeId IN (1,2)) AND p.OwnerUserId IS NOT NULL AND u.Reputation > 250 -- AND u.DisplayName = 'iight' AND ( (Month(p.CreationDate) = 12 AND Day(p.CreationDate) = 25)/* Xmas */ OR (Month(p.CreationDate) = 7 AND Day(p.CreationDate) = 4)/* July 4 */ ) GROUP BY u.DisplayName,u.Reputation ORDER BY 'Number of Questions/Answers/Comments' DESC