Do new members post a lot?

0

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

With 
members as (
   select u.Id as Id, 
          min(p.CreationDate) as FirstPostDate
   from Users u join Posts p
   on u.id = p.OwnerUserId
   group by u.Id
),
posttimes as (
   select m.Id,
          DATEDIFF(hh, m.FirstPostDate, p.CreationDate) as timediff  
   from members m join Posts p
   on m.Id = p.OwnerUserId
)



select * from posttimes

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results