Total post score

0

Please login or register to vote for this query.

(click on this box to dismiss)

Software Engineering

Q&A for professionals, academics, and students working within the systems development life cycle

SELECT
[u].[DisplayName] [User],
[pt].[Name] [Post type],
AVG([p].[Score]) [Average post score]
FROM [Users] [u] (NOLOCK)
JOIN [Posts] [p] (NOLOCK) ON [p].[OwnerUserId] = [u].[Id]
JOIN [PostTypes] [pt] (NOLOCK) ON [pt].[Id] = [p].[PostTypeId]
WHERE [p].[PostTypeId] < 4 AND [p].[ClosedDate] IS NULL
GROUP BY [u].[Id], [u].[DisplayName], [pt].[Name]
HAVING COUNT(1) > 25
ORDER BY [Average post score] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results