2 Task

1

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

select top 10 u.displayName, 
              count(case when Score=0 then 1 end) as zeroScore,
              count(case when Score>0 then 1 end)as posScore,
              count(case when Score<0 then 1 end) as negative,
              count(p.score)as allScore
from users u
join posts p on u.Id=p.OwnerUserId
where p.posttypeid = 1
group by u.displayName
having count(p.id) > 50

Enter Parameters

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