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 NOT EXISTS (
    --  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

fork query

edited dec 7

created dec 7 anonymous