0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools

SELECT TOP 10 u.DisplayName AS имя_пользователя
FROM users u
WHERE u.Id IN (
    SELECT p1.OwnerUserId
    FROM posts p1
    WHERE YEAR(p1.CreationDate) = 2010
) 
AND u.Id IN (
    SELECT p2.OwnerUserId
    FROM posts p2
    WHERE YEAR(p2.CreationDate) = 2015
);

fork query

edited nov 10

created nov 10 anonymous