0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

select OwnerUserId from (select t2.OwnerUserId, datediff(month,t1.FirstPostDate,t2.CreationDate)/12.0 as UserTenurePerPost, t1.FirstPostDate 
from Posts t2 inner join (select OwnerUserId, min(CreationDate) as FirstPostDate
from Posts
group by OwnerUserId) t1
on t2.OwnerUserId = t1.OwnerUserId)t3
group by OwnerUserId
having avg(UserTenurePerPost) < 1

fork query

edited sep 15 19

created sep 15 19 anonymous