2 Task


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for participants in team and individual sport activities

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

Switch to meta site
loading Hold tight while we fetch your results