Total post score


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

[u].[DisplayName] [User],
[pt].[Name] [Post type],
SUM([p].[Score]) [Total 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
GROUP BY [u].[Id], [u].[DisplayName], [pt].[Name]
ORDER BY [Total post score] DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results