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. — , Oct 09 '20 at 09:36
Have also a look at https://stackoverflow.com/questions/24887708/laravel-eloquent-sum-with-groupby — ya-cha, Oct 09 '20 at 13:52

score 1 · Accepted Answer · answered Oct 09 '20 at 09:55

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 09 '20 at 09:55

Kamlesh Paul

1 Answers1