Q&A for professional and enthusiast programmers
select top 100 OwnerUserId as [User Link], SUM(case when VoteTypeId = 3 then -2 when VoteTypeId = 2 then 10 else 15 end) as UncappedRep from Posts p join Votes on PostId = p.id where CommunityOwnedDate is null group by OwnerUserId order by UncappedRep desc