instruction: Who Brings in the Crowds?. Users sorted by total number of views of their questions per day (with a 30-day softener to keep hot new posts from skewing the results).
response: SELECT q.OwnerUserId AS "user_link", COUNT(q.Id) AS Questions, SUM(q.ViewCount / (30 + DATEDIFF(day, q.CreationDate, datadumptime))) AS "question_views_per_day" FROM Posts AS q, (SELECT MAX(LastAccessDate) AS datadumptime FROM Users) AS tmp WHERE q.CommunityOwnedDate IS NULL AND NOT q.OwnerUserId IS NULL AND q.PostTypeId = 1 AND q.OwnerUserId = '##UserId##' GROUP BY q.OwnerUserId