0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users and developers of the Cardano cryptocurrency ecosystem

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

fork query

edited nov 15

created nov 15 anonymous