0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those who base their lives on Jewish law and tradition and anyone interested in learning more

SELECT 
    OwnerUserId, 
    u.DisplayName,
    COUNT(*) AS PostCount
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE PostTypeId = 2
GROUP BY OwnerUserId, u.DisplayName
HAVING COUNT(*) > 1000
ORDER BY PostCount DESC;

fork query

edited dec 12

created dec 12 anonymous