Q&A for network engineers
--select OwnerDisplayName from Posts where OwnerUserId is null group by OwnerDisplayName --select * from Users order by Reputation asc --select Id, PostTypeId, AcceptedAnswerId, ParentId, CreationDate, Score, ViewCount, OwnerUserId, OwnerDisplayName, LastEditorUserId --, LastEditorDisplayName, LastEditDate, LastActivityDate, Title, Tags, AnswerCount, CommentCount,FavoriteCount, ClosedDate, CommunityOwnedDate --from Posts --where PostTypeId=2 order by Score asc --select * from Users u where --u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=1) --and --u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=2) select count(*) as total from Posts p where exists (select u.Id from Users u where u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=1) and u.Id in (select OwnerUserId from Posts where OwnerUserId is not null and PostTypeId=2) and u.Id=p.OwnerUserId ) --group by p.OwnerUserId