ELOQUENT join two tables and order by sum of column

What have you tried so far? You can find lots of examples in the documentation for this

Joins: https://laravel.com/docs/5.5/queries#joins

Post::select('*', DB::raw('SUM(points) as total_points'))
    ->join('points', 'posts.id', '=', 'points.post_id')
    ->orderBy('total_points')
    ->get();

Or even

Post::join('points', 'posts.id', '=', 'points.post_id')
    ->orderByRaw('SUM(points.point)')
    ->get();

Thanks, but it doesn't work...

I get error with this information:

Syntax error or access violation: 1055 'database1.rates.id' isn't in GROUP BY

and the same with all columns

Okay, I solved it, thanks!