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,
    --p.PostTypeId
--FROM Users u
--JOIN Posts p ON u.Id = p.OwnerUserId
--where u.id = 1144035
--WHERE p.PostTypeId = 2 -- Only answers
 -- AND users.id NOT In (
   --   SELECT 1 
     -- FROM Posts p2 
      --WHERE p2.PostTypeId = 1 -- Users with questions
        --AND p2.OwnerUserId = u.Id
 -- )
--GROUP BY u.Id, u.Reputation
--HAVING COUNT(p.Id) > 10 -- At least 10 answers
--ORDER BY u.Reputation DESC; -- Sort by reputation
SELECT 
    u.Id AS UserId,  
    u.Reputation
FROM Users u
JOIN Posts p ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 2 -- فقط پاسخ‌ها
  AND Not exists(
     SELECT 1 , OwnerUserId
      FROM Posts p2 
      WHERE p2.PostTypeId = 1 -- Users with questions
        AND p2.OwnerUserId = u.Id
  )
GROUP BY u.Id, u.Reputation
HAVING COUNT(p.Id) > 10 -- حداقل ۱۰ پاسخ
ORDER BY Reputation DESC; -- مرتب‌سازی بر اساس میزان اعتبار

fork query

edited dec 7

created dec 7 anonymous