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