Average average question score by number of questions


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

  avg(average_question_score) average_average_question_score
    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)=year(current_timestamp)
        and tagname='purim-torah-in-jest'
  group by owneruserid) as average_question_scores
group by number_of_questions
order by number_of_questions asc

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results