How to sort a table by the value of an aggregate function?

Question

Laravel

There are 2 tables:
restaurant: - id, name, ...
reviews: id, restaurant_id, rating.
How can I implement a query to sort restaurants by average rating?

Answer 1

$restaurants = DB::table('restaurants')
            ->join('restaurant_reviews', function($join)
            {
                $join->on('restaurants.id', '=', 'restaurant_reviews.id_restaurant')
                ->orderByRaw('avg(rating)');
            })
            ->get();