select DISTINCT OwnerUserId from Posts where PostTypeId= ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Chinese Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Chinese language

select DISTINCT OwnerUserId
from Posts 
where PostTypeId= 2 and year(CreationDate)= 2014	-- из выборки ответов в 2014
EXCEPT                                            		   	-- убираем 
select DISTINCT  OwnerUserId                      	    	-- выборку вопросов в 2015
from Posts
where PostTypeId= 1 and year(CreationDate)= 2015

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results