0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

-- Query for retrieving user IDs and reputations of users 
--who have posted no questions but more than 10 answers
SELECT Users.Id, Users.Reputation
FROM Users
JOIN Posts ON Users.Id = Posts.OwnerUserId
WHERE Posts.PostTypeId = 2
GROUP BY Users.Id, Users.Reputation
HAVING COUNT(CASE WHEN Posts.PostTypeId = 1 THEN 1 END) = 0 AND 
       COUNT(CASE WHEN Posts.PostTypeId = 2 THEN 1 END) > 10
ORDER BY Users.Reputation DESC;

fork query

edited dec 8

created dec 8 anonymous