How many users have "participated" at least a couple times in the past year.

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language and Usage Meta

Q&A about the site for linguists, etymologists, and serious English language enthusiasts

SELECT 
p.OwnerUserId AS [User Link], 
COUNT(*) AS [Number of Contributions] 
FROM Posts AS p
WHERE p.CreationDate > DATEADD(dd, -365, GETDATE())
GROUP BY p.OwnerUserId
HAVING COUNT(*) >= 4

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results