with questions as (select OwnerUserId as id, sum(case whe...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

with questions as (select OwnerUserId as id, sum(case when score = 0 then 1 end) as zero,
sum (case when score > 0 then 1 end) as nonZero
from Posts where PostTypeId = 1
group by OwnerUserId)
(select displayname, zero, nonZero
from questions q
join users u
on q.id = u.id
where (zero + nonZero) > 50)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results