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.

Physical Fitness

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'
                   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 sites:
loading Hold tight while we fetch your results