Q&A for enthusiasts and power users of the Android operating system
SELECT TOP 10 Id AS [Post Id], Title, Body, ViewCount FROM Posts WHERE ClosedDate IS NULL AND DATEDIFF(dd, GETDATE(), CreationDate) < 2 ORDER BY ViewCount/CAST(GETDATE()-CreationDate AS FLOAT) DESC