Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
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