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.DisplayName, 
    u.Reputation
FROM Users u
JOIN Posts p ON u.Id = p.OwnerUserId
WHERE p.PostTypeId = 2 -- فقط پاسخ‌ها
  AND p.OwnerUserId NOT IN (
      SELECT DISTINCT OwnerUserId 
      FROM Posts 
      WHERE PostTypeId = 1 -- کاربران با پرسش
    --  AND p.OwnerUserId = u.Id
  )
GROUP BY u.Id, u.DisplayName, u.Reputation
HAVING COUNT(p.Id) > 10 -- حداقل ۱۰ پاسخ
ORDER BY Reputation DESC; -- مرتب‌سازی بر اساس میزان اعتبار

fork query

edited dec 7

created dec 7 anonymous