Shows you which questions you've answered that have significant view counts.
Q&A about the site for music historians, critics, and fans
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 and a.OwnerUserId = 73435
ORDER BY [Views per Answer] DESC