How to solve the problem of order by and group by?

Question

MySQL

Good afternoon
There is a base with a product and a user.
Need a list to display the most expensive products of users

Product::orderBy('price','DESC')
            ->groupBy('user_id')->get();

As a result, I get incomplete information where the most expensive ones are sold. How can I modify sql to make group by work correctly?
Thank you.

Answer 1

Since price is not included in the aggregate function, the first available value is taken when grouping. Use MAX(price).