0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

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
GROUP BY 
    P.OwnerUserId
ORDER BY 
    UserId desc;

fork query

edited dec 2

created dec 2 anonymous