2

Please login or register to vote for this query.

(click on this box to dismiss)

Shows you questions that you've answered that have significant view counts.

Q&A about the site for gardeners and landscapers

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
WHERE  a.OwnerUserId = ##UserId:int##
ORDER  BY [Views per Answer] DESC

fork query

edited feb 8 12 e

created feb 8 12 jon.doe6495