Answers awarded multiple bounties


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select P.Id as [Post Link], count(V.bountyAmount) as numAwarded
from Posts P
join Votes V
  on P.Id = V.PostId
  where P.postTypeId = 2 --answers 
group by P.Id
  having count(V.bountyAmount) > 1 --multiple bounties
order by numAwarded desc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results