Enter Query Description
Q&A for professional and enthusiast programmers
-- Enter Query Title -- Enter Query Description -- Enter Query Title -- Enter Query Description SELECT Count(*) FROM Users WHERE DATEDIFF(day,CreationDate, GETDATE()) > 30 AND DATEDIFF(day,LastAccessDate, GETDATE()) < 30 AND (SELECT Count(*) FROM Posts WHERE (Posts.OwnerUserId = Users.Id) AND (DATEDIFF(day, CreationDate, GETDATE()) < 30) ) > 1