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(UpVotes) as upvote_total , count(Posts.Id) as num_posts

from Users

left join Posts on Users.Id = Posts.OwnerUserId

group by Users.Id

order by Users.Id asc

fork query

created nov 11 anonymous