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 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; -- مرتب‌سازی بر اساس میزان اعتبار
--select * from users 
--where  users.id= 1144035
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 -- کاربران با پرسش
  )
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