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 vote201 views3 answers
Slick slider and ACF Pro in WordPress
PHP
1 vote222 views1 answer
Laravel get first letter of each word
PHP Laravel
1 vote209 views2 answers
How to make a child theme in wordpress
PHP
0 vote249 views1 answer
Many to many relationship in laravel example stackoverflow
PHP Laravel
0 vote250 views1 answer
Laravel sql illegal collation
PHP Laravel
0 vote235 views1 answer
Wordpress get post body
PHP Wordpress
20 votes160 views2 answers
Php datetime
PHP
1 vote209 views2 answers
How to pass parameter in routes of laravel
PHP
0 vote231 views1 answer
Check array is associative laravel
PHP Laravel
0 vote251 views1 answer
If is gutenberg page php wp
PHP Wordpress