Q&A for developers and researchers interested in open data
select top 10 Id As [Post Link], Title, viewcount / DATEDIFF(day, creationDate, GETDATE()) from Posts order by( viewcount / DATEDIFF(day, creationDate, GETDATE()))