1

Please login or register to vote for this query.

(click on this box to dismiss)

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],
  (CASE
    WHEN q.AcceptedAnswerId = a.Id THEN 'Yes'
    ELSE null
  END) as [Accepted]
FROM Posts q
INNER JOIN Posts a on q.Id = a.ParentId and a.OwnerUserId = ##UserId##
ORDER BY [Views per Answer] DESC

fork query

edited feb 8 12

created feb 8 12 jon.doe6495