Number of users which asked a second question after their first one was closed

1

Please login or register to vote for this query.

(click on this box to dismiss)

https://chat.stackexchange.com/transcript/message/49597785#49597785

Stack Overflow на русском Meta

Вопросы и ответы о сайте для программистов

-- DECLARE @UserId int = ##userid:int?5026##

-- for each user, select their first two posts
SELECT TOP 100
 T1.Id, postid  
FROM 
  Users as T1
    INNER JOIN 
  (SELECT TOP 500 p.Id as postid
    FROM Posts p
    WHERE p.PostTypeId = 1
    ORDER BY p.CreationDate) as T2
  ON T1.Id = postid
ORDER BY T1.Id

Enter Parameters

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