Reports median and average answer score. The MedianAnswerScore2 is more precise version of median.
Q&A for ebook publishers and readers
declare @median int; --SELECT @median = -- @median + (SELECT count(*) from Posts); SELECT @median = MAX(Score) FROM (SELECT TOP 50 percent Score FROM Posts as PU WHERE PostTypeId = 2 and CommunityOwnedDate IS NULL and PU.OwnerUserId = ##UserId## ORDER BY Score ) as t; declare @median2 int; select @median2 = ( SELECT count(*) FROM (SELECT TOP 50 percent Score FROM Posts as PU WHERE PostTypeId = 2 and CommunityOwnedDate IS NULL and PU.OwnerUserId = ##UserId## ORDER BY Score ) as t WHERE Score = @median ) / (SELECT count(*) FROM Posts as PU WHERE PostTypeId = 2 and CommunityOwnedDate IS NULL and PU.OwnerUserId = ##UserId## and Score = @median ) /*SELECT Count(Posts.Id) AS Answers, @median AS MedianAnswerScore FROM Posts WHERE PostTypeId = 2 and CommunityOwnedDate IS NULL and OwnerUserId = ##UserId##*/ --select @median;