reputation growth rate

1

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select top 20000
       id as [User Link]
     , convert(decimal,datediff(d, creationdate, getdate())) /reputation rate
     , reputation
     , datediff(d, creationdate, getdate()) [#days being a member]
from users
where creationdate > '2019-01-01'
and reputation <> 101
and convert(decimal,datediff(d, creationdate, getdate())) /reputation < 1 
order by rate
       , reputation

Enter Parameters

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