instruction: Answer Count Rank by User.
response: WITH RankedUsers AS (SELECT RANK() OVER (ORDER BY COUNT(*) DESC) AS Rank, OwnerUserId, COUNT(*) AS AnswerCount FROM Posts WHERE PostTypeId = 2 AND NOT OwnerUserId IS NULL GROUP BY OwnerUserId) SELECT Rank, OwnerUserId AS "user_link", AnswerCount FROM RankedUsers WHERE Rank < 100 OR OwnerUserId = '##UserId##' ORDER BY Rank