How to use truncate & avg function in laravel query ?

You can use something like

DB::table('reviews')
	->select(DB:raw('TRUNCATE(AVG(rating),2)')
   ->where('restro_id', 9)
  ->get()

or select the rating using avg aggregation method available in query builder and format it using php (instead of sql truncate)

$rating = number_format(DB::table('reviews')->where('restro_id', 9)->avg('rating'), 2);

@tray2 @s4muel Thank you for quick response guys. I did it like this as suggested by @tray2 -

\App\Models\Review::select(\DB::raw('TRUNCATE(AVG(rating),2) as rating'))
        ->where('restro_id',$id)
        ->get();