Q&A for scientists using computers to solve scientific problems
SELECT v.UserId AS [User Link], SUM(v.BountyAmount) AS [Total Amount], COUNT(v.Id) AS [Count] FROM Votes v INNER JOIN Posts p ON v.PostId=p.Id WHERE (v.VoteTypeId=8) AND (p.OwnerUserId =##userid?8297##) AND (p.PostTypeId=1) GROUP BY v.UserId ORDER BY SUM(v.BountyAmount) DESC