Average question and answer scores

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

select
 sum(Score) / convert(decimal(15,3),count(*)) as AverageQuestionScore
from
 Posts as Q
where
 Q.posttypeid = 3
 
 select
 sum(Score) / convert(decimal(15,3),count(*)) as AverageAnswerScore
from
 Posts as Q
where
 Q.posttypeid = 3

Enter Parameters

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