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 anime and manga fans

-- 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 'Before' 'befaf', COUNT(*) bounties
          FROM Votes
         WHERE CreationDate <= '2010-06-18'
           AND BountyAmount IS NOT NULL
UNION ALL
SELECT 'After', COUNT(*)
          FROM Votes
         WHERE CreationDate > '2010-06-18'
           AND BountyAmount IS NOT NULL

fork query

created jun 27 11 staticbeast