select u.Id as [User Link], u.Reputation, u.DownVotes, ( ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio Meta

Q&A about the site for amateur radio enthusiasts

select
 u.Id as [User Link],
 u.Reputation,
 u.DownVotes,
 ( select count(c.Id) from Comments c
   where c.Text like '%-1%' and c.UserId = u.Id ) as ExplainedDownVotes
from Users u
where u.Id = 40516
order by u.Reputation desc

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results