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, 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