Total views, views per day and score per question.
Q&A for linguists, etymologists, and serious English language enthusiasts
-- How many views your questions received? -- Total views, views per day and score per question. SELECT ViewCount, convert(decimal(10,2), convert(decimal(10,2), ViewCount) / datediff(day, CreationDate, GETUTCDATE())) as [Views per day], Score, Id as [Post Link] FROM Posts WHERE PostTypeId = 1 and OwnerUserId = ##UserId## ORDER BY ViewCount DESC