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.Views) AS TotalViews,
    SUM(U.UpVotes) AS TotalUpVotes,
    SUM(U.DownVotes) AS TotalDownVotes,
    DATEDIFF(DAY, U.CreationDate, GETDATE()) AS AccountAge
FROM 
    Posts P
JOIN 
    Users U 
ON 
    P.OwnerUserId = U.Id
WHERE 
    P.OwnerUserId IS NOT NULL
GROUP BY 
    P.OwnerUserId, U.CreationDate
ORDER BY 
    UserId;

fork query

edited dec 2

created dec 2 anonymous