0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

select distinct top 100 u.DisplayName, u.Id
from Users u
left join
(
  select u.DisplayName, u.Id
  from Users u join
  (
    select p.OwnerUserId
    from Posts p  
    where p.CreationDate between '2010-01-01' and '2010-12-31'
  ) t1 on t1.OwnerUserId = u.Id
) t2 on t2.Id = u.Id
and t2.Id is null
join
(
  select u.DisplayName, u.Id
  from Users u join
  (
    select p.OwnerUserId
    from Posts p  
    where p.CreationDate between '2015-01-01' and '2015-12-31'
  ) t1 on t1.OwnerUserId = u.Id
) t3 on t3.Id = u.Id

fork query

edited dec 8 19

created dec 8 19 anonymous