0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for those interested in the study of the fundamental nature of knowledge, reality, and existence

SELECT TOP 100 USERS.ID, USERS.DISPLAYNAME, COUNT(POSTS.ID) 
FROM USERS 
LEFT JOIN POSTS ON USERS.ID = POSTS.OWNERUSERID 
WHERE POSTS.POSTTYPEID = 1
GROUP BY USERS.ID, USERS.DISPLAYNAME, POSTS.POSTTYPEID 
-- HAVING COUNT(POSTS.ID) = 0

fork query

edited nov 27 anonymous

created jul 3 18 YCF_L