Q&A for professional and enthusiast programmers
SELECT Count(*), sum(cast(subq.ViewCount as bigint)) FROM (SELECT TOP 100 PERCENT ViewCount, Id FROM Posts where ViewCount > 0 AND PostTypeId = 1 AND ClosedDate is NULL AND CommunityOwnedDate is null AND CHARINDEX('<python>', Tags) > 0 AND datediff(day, creationdate, GETDATE()) < 600 AND datediff(day, creationdate, GETDATE()) > 544 ORDER BY ViewCount DESC) AS subq;