Users whose answers received the most bounties from me

1

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 top(##num?100##)
  p.owneruserid as [User Link], p.ownerdisplayname,
  sum(v.bountyamount) as [Total Rep]
  from votes v
inner join posts p on v.postid = p.id
inner join postnotices pn on pn.postid = p.parentid
where votetypeid = 9 
and pn.owneruserid=##userid?8297##
and pn.Postnoticetypeid IN (10,11,12,13,14,15)
---and pn.creationdate < v.creationdate
and v.creationdate = convert(date,pn.deletiondate)
group by p.owneruserid, p.ownerdisplayname
order by sum(v.bountyamount) desc

Enter Parameters

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