0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT Top 10
P.OwnerUserId,
COUNT(P.Id) AS Num_Posts,
COUNT(C.Id) AS Num_Comments
FROM Posts P
LEFT JOIN Comments C
ON C.UserId = P.OwneruserId
WHERE P.CreationDate > DATEADD(YEAR,-5,GETDATE())
GROUP BY P.OwnerUserId

fork query

created jun 5 23 anonymous