0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

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