Laravel - Query Builder - Aggregates

The query builder also provides a variety of methods for retrieving aggregate values like count, max, min, avg, and sum. You may call any of these methods after constructing your query:

    
    use Illuminate\Support\Facades\DB;
    
    $users = DB::table('users')->count();
    
    $price = DB::table('orders')->max('price');
	

Of course, you may combine these methods with other clauses to fine-tune how your aggregate value is calculated:

    
    $price = DB::table('orders')
                    ->where('finalized', 1)
                    ->avg('price');