0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for legal professionals, students, and others with experience or interest in law

SELECT
 TOP 500
    Users.Id AS [User Link],
    Count(AllAnswers.id) as [Total Answers]
FROM
 Users 
 INNER JOIN posts as AllAnswers
    ON AllAnswers.id = Users.Id
WHERE 
AllAnswers.PostTypeId = 2
and AllAnswers.CommunityOwnedDate is null

GROUP BY Users.Id
ORDER BY  [Total Answers] DESC

fork query

edited sep 25 18 Carl.M

created sep 25 18 anonymous