0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for enthusiasts and power users of the Android operating system

select u.DisplayName
from Users u join
( select OwnerUserId
  from Posts
  where CreationDate between '2010-01-01' and '2010-12-31'
  INTERSECT
  select OwnerUserId
  from Posts p  
  where CreationDate between '2015-01-01' and '2015-12-31'
) t on t.OwnerUserId = u.Id;

fork query

edited dec 9 19

created dec 9 19 anonymous