instruction: Popular MongoDB Queries by ViewCount (Year Normalized).
response: SELECT Score, ViewCount, CreationDate, DATEDIFF(YEAR, CreationDate, GETDATE()) + 1 AS "YearsOpen", (ViewCount / (DATEDIFF(YEAR, CreationDate, GETDATE()) + 1)) AS "NewScore", LastActivityDate, Title, Id, Tags FROM Posts WHERE Title LIKE '%mongodb%' OR Tags LIKE '%mongodb%' ORDER BY NewScore DESC