q1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bitcoin

Q&A for Bitcoin crypto-currency enthusiasts

SELECT AVG(CAST(PostCount AS FLOAT)) AS AveragePostCount
FROM (
    SELECT u."Id", u."DisplayName", COUNT(p."Id") PostCount
      FROM "Users" AS u
      LEFT JOIN "Posts" AS p ON u."Id" = p."OwnerUserId"
      GROUP BY u."Id", "DisplayName"
)
AS PostCount;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results