0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for participants in team and individual sport activities

SELECT OwnerUserId AS 'Id', COUNT(OwnerUserId) AS 'NumberPosts'
FROM Posts
GROUP BY OwnerUserId

SELECT AVG(count)
FROM (
SELECT COUNT(*) AS COUNT
FROM Posts
GROUP BY OwnerUserId
) as counts

fork query

edited sep 30 19

created sep 29 19 anonymous