Who's asking/answering the most questions on U.S. holidays?! (And why? ... just kidding, we know why...)
Q&A for Ubuntu users and developers
-- 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' -- ,u.Reputation as 'Reputation' --,count(p.Id) as 'Total Posts' ,p.title -- ,c.Text --,(count(p.Id) + count(c.Id)) as 'Total comments/posts' FROM users u INNER JOIN posts p on p.OwnerUserId = u.id -- LEFT JOIN comments c on c.UserId = u.id WHERE 1=1 AND p.PostTypeId IN (1) 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') -- GROUP BY -- u.DisplayName -- ORDER BY -- count(p.Id) DESC