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,
    AVG(CAST(U.Views as Bigint)) AS AvgViews,
    AVG(U.UpVotes) AS AvgUpVotes,
    AVG(U.DownVotes) AS AbgDownVotes,
    DATEDIFF(DAY, U.CreationDate, GETDATE()) AS AccountAge
FROM
    Posts P
RIGHT JOIN
    Users U
ON
    P.OwnerUserId = U.Id
--WHERE
    --P.OwnerUserId IS NOT NULL
GROUP BY
    P.OwnerUserId, U.CreationDate
ORDER BY rand(P.OwnerUserId);

view current version

edited dec 3

created dec 3 jon.doe45853