select top 10 id, displayname, column1 = (SELECT count(p....

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

select top 10 id, displayname,
column1 = (SELECT count(p.id) FROM posts p 
WHERE p.owneruserid=id and p.posttypeid=1 and p.score=0),
column2 = (SELECT count(p.id) FROM posts p 
WHERE p.owneruserid=id and p.posttypeid=1 and p.score>0)
from users u
where id in (select p.owneruserid from users u 
join posts p on u.id=p.owneruserid 
where p.posttypeid=1
GROUP BY p.owneruserid
having count(p.id)>50)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results