SELECT COUNT(*) FROM Users LEFT JOIN Comments ON Users.I...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Musical Practice and Performance Meta

Q&A about the site for musicians, students, and enthusiasts

-- How many users have never commented on anything, 
-- of the users who joined in 2024?

SELECT COUNT(*) FROM Users
LEFT JOIN Comments ON Users.Id = Comments.UserId
WHERE Users.CreationDate >= '2024-01-01 00:00:00' AND
Users.CreationDate < '2025-01-01 00:00:00'

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results