0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

SELECT TOP ##MaxUsers?200##
        a.OwnerUserId AS [User Link],
        Count(a.Id) AS [Total Answers]
FROM    Posts AS a
   JOIN Posts AS q
     ON a.ParentId = q.Id
WHERE
        a.OwnerUserId is not NULL
    AND q.postTypeId = 1
    AND a.postTypeId = 2
GROUP BY
        a.OwnerUserId
ORDER BY
        Count(a.Id) DESC

fork query

edited sep 19 20

created sep 19 20 Temani.Afif