Q&A for SharePoint enthusiasts
SELECT count(*) FROM users WHERE creationdate > '2024-01-01 00:00:00' AND EXISTS (SELECT id FROM posts WHERE users.id = posts.owneruserid AND commentcount = 0)