select number_of_questions, avg(average_question_score) ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mi Yodeya

Q&A for those who base their lives on Jewish law and tradition and anyone interested in learning more

-- variant of http://data.stackexchange.com/judaism/query/460515

select
  number_of_questions,
  avg(average_question_score) average_average_question_score
from
  (select
    count(p.id) number_of_questions,
    (0.1*sum(score))/(0.1*count(p.id)) average_question_score
  from posts p
       join posttags pt on p.id=pt.postid
       join tags t on pt.tagid=t.id
  where posttypeid=1 -- q
        and year(creationdate)>=2015
  group by owneruserid, year(creationdate)) as average_question_scores
group by number_of_questions
order by number_of_questions asc

Enter Parameters

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