0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for SharePoint enthusiasts

DECLARE @UserId INT = ##UserId##;

-- Calculate average scores for answers, questions, and total posts
SELECT 
    AVG(CASE WHEN p.PostTypeId = 2 THEN p.Score END) AS AverageAnswerScore,
    AVG(CASE WHEN p.PostTypeId = 1 THEN p.Score END) AS AverageQuestionScore,
    AVG(p.Score) AS AveragePostScore
FROM 
    Posts p
WHERE 
    p.OwnerUserId = @UserId

fork query

edited oct 20

created oct 20 securityparanoid46002