0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT 
    u.Id AS UserId,
    u.DisplayName,
    COUNT(c.Id) AS TotalComments,
    SUM(c.Score) AS TotalUpvotes
FROM 
    Comments c
INNER JOIN 
    Users u ON c.UserId = u.Id
GROUP BY 
    u.Id, u.DisplayName
ORDER BY 
    u.Id;

fork query

edited nov 11

created nov 11 anonymous