2 Task


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

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 main site
loading Hold tight while we fetch your results