0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

SELECT 
    u.Id, 
    u.Reputation,
    (SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = u.Id) AS AnswerCount
FROM Users u
WHERE 
    NOT EXISTS (SELECT 1 FROM Posts WHERE PostTypeId = 1 AND OwnerUserId = u.Id)
    AND (SELECT COUNT(*) FROM Posts WHERE PostTypeId = 2 AND OwnerUserId = u.Id) > 10
ORDER BY u.Reputation DESC;

fork query

edited dec 13

created dec 13 anonymous