Laravel join query sum example

“laravel join query sum example” Coderfunda Code Answer’s

sql select sum group by id laravel join

0

1

$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue'))

2

         ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id')

3

         ->where('analytics.date', Carbon::today()->toDateString())

4

         ->get();

Source: stackoverflow.com

laravel join query sum example

0

1

$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue'))

2

         ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id')

3

         ->where('analytics.date', Carbon::today()->toDateString())

4

         ->get();

5

​