0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals and students of engineering

SELECT TOP 500
    P.OwnerUserId AS UserId,
    COUNT(P.Id) AS TotalPosts,
    AVG(P.Score) AS AvgPostScore,
    SUM(U.UpVotes) AS TotalUpVotes,
    SUM(U.DownVotes) AS TotalDownVotes,
    SUM(U.Views) AS TotalViews
FROM 
    Posts P
JOIN 
    Users U 
ON 
    P.OwnerUserId = U.Id and U.Id != -1
GROUP BY 
    P.OwnerUserId
ORDER BY 
    UserId;

fork query

edited dec 2

created dec 2 anonymous