Q&A about the site for gardeners and landscapers
-- How high would my reputation approximately be when there was no cap or CW?
DECLARE @UserId int = ##UserId##
WHEN VoteTypeId = 1 THEN 15 -- Accepted answer.
WHEN VoteTypeId = 2 AND PostTypeId = 1 THEN 5 -- Upvoted question
WHEN VoteTypeId = 2 AND PostTypeId = 2 THEN 10 -- Upvoted answer.
WHEN VoteTypeId = 3 THEN -2 -- Downvote.
WHEN VoteTypeId = 9 THEN BountyAmount -- Earned Bounty
END) AS UncappedReputation
Posts ON Posts.Id = Votes.PostId
Posts.OwnerUserId = @UserId