Unique + active users, last month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
  COUNT(DISTINCT p.OwnerUserId) + 
  COUNT(DISTINCT p.LastEditorUserId) AS [UniqueUsers],
  COUNT(DISTINCT IIF(ou.Reputation > 201, ou.Id, NULL)) +
  COUNT(DISTINCT IIF(eu.Reputation > 201, eu.Id, NULL)) AS [UniqueActive]
FROM Posts p
INNER JOIN Users ou ON p.OwnerUserId = ou.Id
LEFT JOIN Users eu ON p.LastEditorUserId = eu.Id
WHERE LastActivityDate >= DATEADD(MONTH, -1, GETDATE());

Enter Parameters

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