Q&A for active researchers, academics and students of physics
select top 100 u.Id as [User Link], (select count(*) from Votes v join Posts p on p.Id = v.PostId where p.OwnerUserId = u.Id and v.VoteTypeId = 2) as [Upvoted], (select count(*) from Votes v join Posts p on p.Id = v.PostId where p.OwnerUserId = u.Id and v.VoteTypeId = 3) as [Downvoted], (select count(*) from Votes v join Posts p on p.Id = v.PostId where p.OwnerUserId = u.Id and v.VoteTypeId = 2) - (select count(*) from Votes v join Posts p on p.Id = v.PostId where p.OwnerUserId = u.Id and v.VoteTypeId = 3) as [Net Vote Score], u.Reputation from Users u order by u.Reputation