0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment

Select
  U.Id,
  DisplayName,
  Sum(P.Score * 5) 
From Users U
Inner Join Posts P
  On U.Id = P.OwnerUserId

Where PostTypeId = 1 And DeletionDate Is Null

Group By U.Id, U.DisplayName

Order By Sum(Score * 5) Desc

fork query

edited nov 13 19 anonymous

created nov 13 19 jbueno