0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

SELECT 
    u.Id AS UserId,
    u.DisplayName,
    u.Reputation,
    COUNT(DISTINCT c.PostId) AS UniqueCommentedPosts,
    COUNT(DISTINCT CASE WHEN p.PostTypeId = 2 AND p.Id = p.AcceptedAnswerId THEN p.Id END) AS CorrectAnswers
FROM 
    Users u
LEFT JOIN 
    Posts p ON u.Id = p.OwnerUserId
LEFT JOIN 
    Comments c ON u.Id = c.UserId
WHERE 
    u.CreationDate <= DATEADD(month, -6, GETDATE())
GROUP BY 
    u.Id, u.DisplayName, u.Reputation
HAVING 
    COUNT(DISTINCT c.PostId) >= 10
ORDER BY 
    CorrectAnswers DESC;

fork query

edited dec 13

created oct 31 anonymous