Number of questions by people with the Informed badge

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

Enter Parameters

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