Finds questions that have answers competing with yours. http://stackoverflow.com/badges/119/sportsmanship
Q&A for project managers
SELECT DISTINCT q.Score, q.Id AS [Post Link], q.AnswerCount - 1 AS [Competing Answers], q.CreationDate FROM Posts q INNER JOIN Posts a ON a.ParentId = q.Id WHERE a.OwnerUserId = ##UserId:int## AND a.Score > 0 AND q.AnswerCount > 1 ORDER BY q.CreationDate DESC