Calculate how much reputation I gained from the rep change

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

Q&A for committed Christians, experts in Christianity and those interested in learning more

select
    SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) AS [Up Votes BEFORE],
    SUM(CASE WHEN VoteTypeId = 2 THEN 1 ELSE 0 END) * 5 AS [Down Votes AFTER]
from
    Votes v inner join Posts p on v.PostId=p.Id
where
    p.OwnerUserId=##UserId##

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results