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) 
, POSTS.POSTTYPEID
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