What day of the week are most bounties offered?

0

Please login or register to vote for this query.

(click on this box to dismiss)

You probably won't be surprised by the result!

Drupal Answers Meta

Q&A about the site for Drupal developers and administrators

-- What day of the week are most bounties offered?
-- You probably won't be surprised by the result!

SELECT COUNT(*) as Bounties, CASE (DATEPART(dw, CreationDate) + @@DATEFIRST) % 7
    WHEN 1 THEN 'Sunday'
    WHEN 2 THEN 'Monday'
    WHEN 3 THEN 'Tuesday'
    WHEN 4 THEN 'Wednesday'
    WHEN 5 THEN 'Thursday'
    WHEN 6 THEN 'Friday'
    WHEN 0 THEN 'Saturday'
  END AS Weekday FROM Votes WHERE VoteTypeId = 8
GROUP BY DATEPART(dw, CreationDate)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results