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 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)      as 'Number of Questions/Answers'
   
   -- ,u.Reputation     as 'Reputation'
   --,count(p.Id)         as 'Total Posts'
   --,p.Title             as 'Title'
   --,p.CreationDate      as 'Date'
   -- ,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'
    OR
    p.CreationDate BETWEEN '2012-12-25 00:00:00' AND '2012-12-25 23:59:59'
    )

GROUP BY
  u.DisplayName
ORDER BY
--  p.CreationDate DESC
  count(p.Title) DESC

Enter Parameters

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