0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for power users of web applications

SELECT AVG(CAST(sub.NumQuestions as Float))
FROM (
  SELECT 
    COUNT(*) as NumQuestions
  FROM
    Posts p INNER JOIN Users u ON p.OwnerUserId=u.id
  WHERE
    p.PostTypeId = 2
  GROUP BY u.id) sub
--https://meta.stackexchange.com/questions/2677/database-schema-documentation-for-the-public-data-dump-and-sede
--https://stackoverflow.com/questions/11106170/sql-avg-returning-an-int

fork query

edited nov 18 19 anonymous

created feb 28 18 Aidan.San