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

WITH Users2010 AS (
    SELECT DISTINCT OwnerUserId
    FROM posts
    WHERE YEAR(CreationDate) = 2010
),
Users2015 AS (
    SELECT DISTINCT OwnerUserId
    FROM posts
    WHERE YEAR(CreationDate) = 2015
)
SELECT TOP 10 u.DisplayName AS имя_пользователя
FROM users u
JOIN Users2010 u2010 ON u.Id = u2010.OwnerUserId
LEFT JOIN Users2015 u2015 ON u.Id = u2015.OwnerUserId
WHERE u2015.OwnerUserId IS NULL

fork query

edited nov 10

created nov 10 anonymous