Shows you questions that you've answered that have significant view counts.
Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs
SELECT TOP 100 q.ViewCount AS [Views],
ROUND(q.ViewCount / q.AnswerCount, 2) AS [Views per Answer],
q.AnswerCount AS [Answer Count],
q.Id AS [Post Link],
a.Score AS [Answer Score],
WHEN q.AcceptedAnswerId = a.Id THEN 'Yes'
END) AS [Accepted]
FROM Posts q
INNER JOIN Posts a
ON q.Id = a.ParentId
WHERE a.OwnerUserId = ##UserId:int##
ORDER BY [Views per Answer] DESC