0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

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;

view current version

edited dec 3

created dec 3 jon.doe45853