select owneruserid as [User Link], case when count(*)>0 t...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

select owneruserid as [User Link],
case when count(*)>0 then
cast(sum(case when answercount=0 then 1 else 0 end)as real)
else null
end
as UnansweredQuestions
from posts
where posttypeid=1
group by owneruserid
order by UnansweredQuestions desc

Enter Parameters

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