Questions with bounties and AnswerCount = 0

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

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 Votes.VoteTypeId = 9 AND Posts.AnswerCount = 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