Answers awarded multiple bounties

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for 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

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