Number of questions by people with the Informed badge


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 sum(case when is not null then 1 else 0 end) as Informed,
       sum(case when is null then 1 else 0 end) as Uninformed
from Posts as p
left outer join Badges b
  b.userid = p.owneruserid
  and = 'Informed'
where p.PostTypeId = 1

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results