0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

select Users.Id, sum(Comments.Score) as cmt_upvote_total , count(Comments.Id) as num_cmt

from Users

left join Comments on Users.Id = Comments.UserId

group by Users.Id

order by Users.Id asc

fork query

edited nov 11

created nov 11 anonymous