2 Task


Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

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