0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

SELECT TOP 10 
    Users.DisplayName AS UserName -- Имя пользователя
FROM 
    Users
WHERE 
    Users.Id IN (
        SELECT 
            DISTINCT Posts.OwnerUserId
        FROM 
            Posts
        WHERE 
            YEAR(Posts.CreationDate) = 2010
    )
    AND Users.Id IN (
        SELECT 
            DISTINCT Posts.OwnerUserId
        FROM 
            Posts
        WHERE 
            YEAR(Posts.CreationDate) = 2015
    );

view current version

edited dec 4

created dec 3 jon.doe46476