Holiday Work Horse

1

Please login or register to vote for this query.

(click on this box to dismiss)

Who's asking/answering the most questions on U.S. holidays?! (And why? ... just kidding, we know why...)

Meta Stack Exchange

Q&A for meta-discussion of the Stack Exchange family of Q&A websites

-- Holiday Workers 
-- Who's asking/answering/commenting the most
-- on typical U.S. holidays?! And why? (just kidding)
SELECT
   u.DisplayName
  ,count(*)
  
FROM
  users u
    LEFT JOIN posts p    on p.OwnerUserId = u.id
    LEFT JOIN comments c on c.UserId      = u.id

WHERE
  u.Reputation > 250
  AND (p.CreationDate BETWEEN '2012-11-28 00:00:00' AND '2012-11-28 23:59:59')

GROUP BY
  u.DisplayName

ORDER BY
  count(*) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results