Answers that wowed

2

Please login or register to vote for this query.

(click on this box to dismiss)

These answers elicited a "wow!" comment from the original poster.

Code Review

Q&A for peer programmer code reviews

SELECT TOP 500 PostId AS [Post Link]
     , Answers.OwnerUserId AS [User Link]
     , Answers.Score AS [Answer Score]
     , Comments.Id AS [Comment Link]
    FROM Posts AS Questions
        INNER JOIN Posts AS Answers
            ON Answers.ParentId = Questions.Id
        INNER JOIN Comments
            ON Comments.PostId = Answers.Id
    WHERE
        Comments.UserId = Questions.OwnerUserId
        AND LOWER(SUBSTRING(Comments.Text, 1, 30)) LIKE '%wow%'
    ORDER BY [Answer Score];

Enter Parameters

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