0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

-- 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 Comments.UserId IS NULL
AND Users.CreationDate >= '2024-01-01 00:00:00' 
AND Users.CreationDate < '2025-01-01 00:00:00'

view current version

edited oct 11

created oct 11 jon.doe45961