Which of my answers have helped the Internet?


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.

Gardening and Landscaping Meta

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],
                   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

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results