0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT TOP 10 DisplayName, COUNT(Posts.Id) AS Count_Posts
FROM Users
LEFT JOIN Posts ON Users.Id = Posts.OwnerUserId 
WHERE Posts.Id IS NULL
GROUP BY Users.Id, DisplayName, PostTypeId 
HAVING COUNT(Posts.Id) = 0;

view current version

edited dec 2

created dec 2 anonymous