0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer enthusiasts and power users

select u.DisplayName,
       count(case when p.PostTypeId = 1 and p.Score = 0 then 1 end) equals, 
       count(case when p.PostTypeId = 1 and p.Score > 0 then 1 end) bolshe 
from Users u join Posts p on u.id = p.OwnerUserId 
group by u.DisplayName 
having count(case when p.PostTypeId = 1 then 1 end) > 50;

view current version

edited nov 22 17

created nov 22 17 anonymous