Q&A for Ubuntu users and developers
select top 100 C.id as [User Link], sum(D.downvotes) as downvotes, datediff(dd,getdate(),C.CreationDate) as age from Users as C inner join ( select A.id as postId, A.ownerUserId as userId, B.downvotes from Posts as A inner join ( select postId, count(*) as downvotes from Votes where voteTypeId = 3 group by postId ) as B on A.id = B.postId ) as D on C.id = D.userId where C.Reputation != 1 group by C.id,age,C.CreationDate order by downvotes desc