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...)

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

view current version

edited jan 3 13

created jan 3 13 iight