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
    U.Id AS UserId,
    DATEDIFF(DAY, U.CreationDate, GETDATE()) AS AccountAgeDays,
    U.UpVotes,
    U.DownVotes,
    U.Views,
    ISNULL(AVG(P.Score), 0) AS AvgPostScore,
    COUNT(P.Id) AS TotalPosts
FROM
    Users U
LEFT JOIN
    Posts P
ON
    U.Id = P.OwnerUserId
GROUP BY
    U.Id, U.CreationDate, U.UpVotes, U.DownVotes, U.Views
HAVING
    COUNT(P.Id) > 5
ORDER BY
    UserId
OFFSET 0 ROWS FETCH NEXT 500 ROWS ONLY; -- Fetch 500 users

fork query

edited dec 2

created oct 2 anonymous