0

Please login or register to vote for this query.

(click on this box to dismiss)

Number of bounties created on each days, ordered from most to least.

Q&A for peer programmer code reviews

-- Enter Query Title
-- Enter Query Description

SELECT CASE
         WHEN CreationDate < '2010-06-18' THEN 'Before'
         ELSE 'After'
       END 'befaf',
       CreationDate,
       COUNT(*) bounties
  FROM Votes
 WHERE BountyAmount IS NOT NULL
 GROUP BY CreationDate
 ORDER BY bounties DESC

fork query

created jun 27 11 staticbeast