0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT TOP 1000 p.OwnerDisplayName, 
    SUM(p.Score) AS [Total Score], 
    COUNT(p.Id) AS [Number of Posts], 
    MIN(p.CreationDate) as [First Post],
    MAX(p.CreationDate) as [Last Post],
    DATEDIFF(day, MIN(p.CreationDate), MAX(p.CreationDate)) as Duration
FROM Posts p
WHERE p.OwnerUserId IS NULL
GROUP BY p.OwnerDisplayName
having SUM(p.Score) > 1000
ORDER BY MAX(p.CreationDate) DESC

fork query

edited dec 9 17 rene

created dec 20 13 jon.doe12549