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.
convert(decimal(10,2), ViewCount) /
datediff(day, CreationDate, GETUTCDATE())) as [Views per day],
Id as [Post Link]
WHERE PostTypeId = 1 and OwnerUserId = ##UserId##
ORDER BY ViewCount DESC