Laravel join query sum example

Sql select sum group by id laravel join

$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue'))
         ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id')
         ->where('analytics.date', Carbon::today()->toDateString())
         ->get();

Source: stackoverflow.com

Laravel join query sum example

$users = User::select('users*', 'analytics.*', DB::raw('SUM(analytics.revenue) As revenue'))
         ->leftJoin('analytics', 'analytics.user_id', '=', 'users.id')
         ->where('analytics.date', Carbon::today()->toDateString())
         ->get();

Source: stackoverflow.com

Similar codes

0 vote221 views1 answer
Php createFromFormat day of week
PHP
0 vote225 views1 answer
Aws s3 laravel package
PHP Laravel
-1 vote257 views1 answer
Php get file location
PHP
2 votes197 views1 answer
Laravel 8 delete by id
PHP
1 vote234 views1 answer
Array_last in laravel 8
PHP Laravel
0 vote229 views1 answer
Laravel catch TokenMismatchException
PHP Laravel
0 vote186 views1 answer
Cambiare pagina php
PHP
6 votes194 views2 answers
How many products can a laravel ecommerce handle
PHP Laravel
0 vote235 views1 answer
Wordpress get all published post
PHP
1 vote205 views2 answers
+1 month php
PHP