Q&A about the site for members of the workforce navigating the professional setting
SELECT TOP 20 p.OwnerUserId, u.DisplayName, COUNT(*) FROM Posts p INNER JOIN Users u ON p.OwnerUserId = u.Id WHERE p.PostTypeId = 1 AND p.DeletionDate IS NULL AND p.OwnerUserId IS NOT NULL GROUP BY p.OwnerUserId, u.DisplayName ORDER BY COUNT(*) DESC;