SELECT TOP 10 u.Id, u.DisplayName, COUNT(*), SUM(Score) F...

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 TOP 10 u.Id, u.DisplayName, COUNT(*), SUM(Score)
FROM Posts p
JOIN Users u ON p.OwnerUserId = u.Id
WHERE p.CreationDate > '2013-01-01'
AND u.DisplayName = 'Jon Skeet'
GROUP BY u.Id, u.DisplayName
ORDER BY SUM(Score) DESC

-- FROM, WHERE, GROUP, SELECT, ORDER

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results