Q&A for students, teachers, polyglots, and anyone interested in the techniques of second-language acquisition
select top 500 u.Id as [User Link] , datediff(dd, u.creationdate, GETDATE() ) as [Days] , count(a.Id) as [Total Answers] , cast(count(a.Id) as float)*sign(count(a.Id) - 99) / datediff(dd, u.creationdate, GETDATE()) as [Answers/Day Ratio] , avg(a.score * 1.0) as [AvgScorePerAnswer] from Users u inner join Posts a on a.OwnerUserId = u.Id where a.PostTypeId=2 group by u.Id, u.creationdate order by [Answers/Day Ratio] desc