new users

0

Please login or register to vote for this query.

(click on this box to dismiss)

SharePoint

Q&A for SharePoint enthusiasts

SELECT 
   DATEPART(MONTH, CreationDate) AS MONTHNumber, 
   SUM(CASE WHEN PostTypeId = 1 THEN 1 ELSE 0 END) AS TotalQuestionsCount, 
   SUM(CASE WHEN PostTypeId = 2 THEN 1 ELSE 0 END) AS TotalAnswersCount
FROM Posts
WHERE OwnerUserId IN (
    SELECT Id 
    FROM Users 
    WHERE CreationDate BETWEEN '2008-01-01' AND '2024-12-31'
)
AND CreationDate <= DATEADD(DAY, 30, (SELECT MIN(CreationDate) FROM Posts))
GROUP BY DATEPART(MONTH, CreationDate)
ORDER BY MONTHNumber;

Enter Parameters

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