Active Questions with bounties

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

SELECT TOP 100
    Posts.Id as [Post Link],
    Posts.OwnerUserId as [User Link],
    Posts.Score as [Post Score],
    MIN(Posts.LastEditDate) as [LastEditDate],
    COUNT(BountyAmount) as [# of Bounties],
    SUM(BountyAmount) as [Bounty Total]
FROM Votes 
  JOIN Posts 
  ON Posts.Id = Votes.PostId
WHERE Posts.AnswerCount = 0 
  AND Posts.CreationDate > (GETDATE()-10) 
  AND BountyAmount > 0
GROUP BY
    Posts.Id,
    Posts.OwnerUserId,
    Posts.Score
ORDER BY [Bounty Total] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results