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)
u.DisplayName as 'User Name'
-- ,u.Reputation as 'Reputation'
,count(p.Id) as 'Total Posts'
--,(count(p.Id) + count(c.Id)) as 'Total comments/posts'
LEFT JOIN posts p on p.OwnerUserId = u.id
-- LEFT JOIN comments c on c.UserId = u.id
AND p.PostTypeId IN (2)
AND p.OwnerUserId IS NOT NULL
AND u.Reputation > 250
-- AND u.DisplayName = 'iight'
-- AND (p.CreationDate < '2012-11-29' AND p.CreationDate > '2012-11-27')
AND (p.CreationDate BETWEEN '2012-11-28 00:00:00' AND '2012-11-28 23:59:59')