with data1(Id) as( select distinct OwnerUserId from Posts...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

with data1(Id) as(
  select distinct OwnerUserId
  from Posts
  where year(CreationDate)=2010
),
data2(user_name,date_create) as(
  select distinct a.OwnerDisplayName,
   a.CreationDate
  from Posts a
   inner join data1 on data1.Id=a.OwnerUserId
   where year(CreationDate) <> 2015
)
select *
from data2

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results