/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

0 vote290 views1 answer
Postgres truncate with cascade
SQL
-1 vote293 views3 answers
Check table exist postgresql
SQL
0 vote319 views1 answer
Search from comma separated values in sql server
SQL
5 votes316 views1 answer
Sysdate in oracle sql
SQL
32 votes325 views6 answers
Insert select
SQL
0 vote299 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote246 views2 answers
Jupyter notebook connect to database
SQL
3 votes342 views1 answer
Where id is in list sql
SQL
0 vote293 views1 answer
How to install mysql without admin rights
SQL
0 vote281 views1 answer
Postgres float to int
SQL