1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

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

edited sep 27 12

created sep 27 12 anonymous