List of users with the highest sum of points

Question

I would like to create a ranking ordered by the user who has the most "points" scored.

My "points" table has these fields: user_id, type and quantity.

In this example, user 1 has a total of 4 points, while user 2 has a total of 8.

My dilemma after several unsuccessful tests, is to create a cycle that shows users with the highest sum of "quantity".

How can I do?

Nothing in particular unfortunately, I can not find a logic of how to behave, I am stuck. — user12997763
– user12997763, Commented Oct 9, 2020 at 9:36
Have also a look at stackoverflow.com/questions/24887708/… — ya-cha
– ya-cha, Commented Oct 9, 2020 at 13:52

Kamlesh Paul · Accepted Answer · 2020-10-09 09:55:00Z

1

you need to use selectRaw(sum(columan) as total) then group

Point::selectRaw("SUM(quantity) as total_quantity,user_id")->groupBy('user_id')->get()

answered Oct 9, 2020 at 9:55

Kamlesh Paul

12.5k2 gold badges23 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1