0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @UserId int = ##UserId##;

SELECT 
  COUNT(DISTINCT Answers.Id) AS Answers,
  SUM(Answers.Score) AS Votes,
  SUM(Votes.BountyAmount) AS Bounty
FROM 
  Posts AS Answers
  LEFT JOIN Votes ON (Answers.Id = Votes.PostId)
WHERE 
  Answers.OwnerUserId = @UserId AND 
  Answers.PostTypeId = 2;

fork query

edited aug 22 17 Martin.Parenteau

created mar 24 14 Eric Koleda