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)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

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