select sum(case when usersCounter.counter = 0 then 1 else...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Portuguese Language

Q&A for linguists, teachers and learners wanting to discuss the finer points of the Portuguese language

select sum(case when usersCounter.counter = 0 then 1 else 0 end) as question0

from (
  select ( 
    select count(*)
    from Posts
    where Posts.OwnerUserId = Users.Id
    ) as counter
  from Users 
) as usersCounter

Enter Parameters

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