Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing
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