0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select Reputation, round(avg(Score + 0.0),2) as [Avg Score],  
count(*) as [Total Answers],   
sum(case when Score < 0 then 1 else 0 end) 
as [Negative Scored Answers]from Posts 
join Users u on u.Id = OwnerUserId
where Posts.CreationDate > '01/01/2013'
and PostTypeId = 2
and u.Id=##userId##
group by Reputation

fork query

edited jan 15 14

created jan 15 14 Glenn Teitelbaum