0

Please login or register to vote for this query.

(click on this box to dismiss)

Measurement of the number of bounties placed before and after the any user-any bounty implementation.

Q&A for Ubuntu users and developers

-- Bounty usage since allowing bounties on other people's questions
-- Measurement of the number of bounties placed before and after the 
-- any user-any bounty implementation.

SELECT TOP 5 'Before', CreationDate, COUNT(*) bounties
          FROM Votes
         WHERE CreationDate > '2010-06-18'
           AND BountyAmount IS NOT NULL
         GROUP BY CreationDate
UNION
SELECT TOP 5 'After', CreationDate, COUNT(*) bounties
          FROM Votes
         WHERE CreationDate <= '2010-06-18'
           AND BountyAmount IS NOT NULL
         GROUP BY CreationDate
ORDER BY bounties DESC

fork query

created jun 27 11 staticbeast