Which of my answers have helped the Internet?

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.

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results