0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences

select p.OwnerUserId
from Posts p
where (
        (
          p.CreationDate >= '2014-01-01'
          and p.CreationDate < '2015-01-01'
        ) 
        and p.PostTypeId = 2
      )
      and p.OwnerUserId <> (
        select DISTINCT p2.OwnerUserId 
        from Posts p2  
        where
        (
          (
            p2.CreationDate >= '2015-01-01'
            and p2.CreationDate < '2016-01-01'
          )
        )
        and p2.PostTypeId = 1
        and p.OwnerUserId = p2.OwnerUserId
      )
group by p.OwnerUserId

view current version

edited dec 12

created dec 12 jon.doe46562