select u.Id as [User Link], u.Reputation, qc.QuestionCoun...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select u.Id as [User Link], u.Reputation, qc.QuestionCount, ac.AnswerCount
from Users u
inner join (select COUNT(*) as QuestionCount, OwnerUserId from Posts where PostTypeId=1 group by OwnerUserId) qc on qc.OwnerUserId = u.Id
left outer join (select COUNT(*) as AnswerCount, OwnerUserId from Posts where PostTypeId=2 group by OwnerUserId) ac on ac.OwnerUserId = u.Id
where u.Reputation > 2000
and qc.QuestionCount < 5
and ac.AnswerCount IS NULL

Enter Parameters

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