0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain

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