Q&A about the site for enthusiasts and power users of the Android operating system
--select * from posttypes; select count(*) from (select a.id from (select users.id from users join posts p on users.id = p.OwnerUserId and PostTypeId = 1 group by users.id) a left outer join posts on a.id = posts.OwnerUserId and PostTypeId = 2 where posts.id is not NULL ) b