0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for ebook publishers and readers

SELECT 
    u.Id AS UserId, 
    u.Reputation
FROM Users u
JOIN Posts p ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 2 -- Only answers
  AND NOT EXISTS (
      SELECT 1 
      FROM Posts p2 
      WHERE p2.PostTypeId = 1 -- Users with questions
  )
GROUP BY u.Id, u.Reputation
HAVING COUNT(p.Id) > 10 -- At least 10 answers
ORDER BY u.Reputation DESC; -- Sort by reputation

fork query

created dec 7 anonymous