select count (Id) from users full outer join (select Owne...

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 count (Id) from users 
    full outer join
   (select OwnerUserId, count (id) as post from posts 
    where PostTypeId = 1
    group by OwnerUserId) as nou
    on users.id = nou.OwnerUserId
    where post is null

Enter Parameters

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