0

Please login or register to vote for this query.

(click on this box to dismiss)

Enter Query Description

Q&A for anime and manga fans

-- Enter Query Title
-- Enter Query Description

SELECT u.Id, u.DisplayName, COUNT(*) AS '# Posts'
FROM Posts p
LEFT JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.CreationDate > DATEADD(dd,-21,GETUTCDATE())
GROUP BY u.Id, u.DisplayName
ORDER BY COUNT(*) DESC

fork query

created may 29 11 Rebecca Chernoff