Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism
with x(Rep, CreationDate, LastPostedDate, Id) as( select a.Reputation, a.CreationDate, max(b.CreationDate), a.Id from Users a, Posts b where b.OwnerUserId = a.Id group by a.Reputation,a.CreationDate,a.Id ) select top 200 Rep, round(cast(Rep as float)/DATEDIFF(dd,CreationDate,LastPostedDate),1) RepPerDay, Id as [User Link] from x where DATEDIFF(dd,CreationDate,LastPostedDate) > 30 and Id = 646591 order by RepPerDay desc;