0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who use Blender to create 3D graphics, animations, or games

SELECT SUM(a.Score) as 'Total Score',
COUNT(u.Id) as '# Answers',
u.Id AS [User Link]
FROM Posts p 
JOIN Posts a ON p.Id = a.ParentId
JOIN Users u ON a.OwnerUserId = u.Id
WHERE p.PostTypeId = 1 AND p.CreationDate > '2024-05-01'
-- We want one row per user:
GROUP BY u.Id

fork query

edited aug 10

created aug 10 anonymous