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;