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

Physical Fitness Meta

Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- 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 sites:
loading Hold tight while we fetch your results