Average Score for Questions and Answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical Analysis

Q&A for statisticians, data analysts, data miners and data visualization experts

SELECT
PostTypeID,
SUM (Score) AS SUM_SCORE,
COUNT(*) AS COUNT_SCORE,
AVG(CAST(Score AS DECIMAL(12,2))) AS AVG_SCORE
FROM 
    Posts
GROUP BY
    PostTypeID    
HAVING PostTypeID < 3
fork query

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
Results Messages Graph Execution Plan
Download CSV Download XML
:records rows returned in :time ms:cached