select count(p.id) number_of_questions, (0.1*sum(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/460514
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)=year(current_timestamp)
and tagname='purim-torah-in-jest'
group by owneruserid, year(creationdate)
order by number_of_questions desc

Enter Parameters

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