/SQL/Sql select sum group by id laravel join

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

Similar codes

1 vote242 views1 answer
Find a column in all tables postgres
SQL
0 vote243 views2 answers
Jsonb
SQL
1 vote211 views1 answer
Stored procedure return value
SQL
0 vote233 views1 answer
Heidisql check how much space a row
SQL
0 vote229 views1 answer
No suitable driver found for sqlite
SQL
5 votes254 views1 answer
Mysql where one year ago
SQL
5 votes232 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote239 views1 answer
Contact mysql column field
SQL
0 vote230 views1 answer
Update set with inner join oracle
SQL
16 votes258 views2 answers
Mysql date between two dates
SQL