/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

6 votes308 views2 answers
Mysql timestamp to date
SQL
0 vote295 views1 answer
How to add unique key constraint in mysql
SQL
0 vote282 views1 answer
Sql drop default
SQL
0 vote279 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote287 views1 answer
What is ssrs and ssis in sql server
SQL
0 vote281 views1 answer
Rollback to name in sql
SQL
0 vote302 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote308 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote266 views1 answer
Get all employees if name ends with in sql
SQL
7 votes330 views2 answers
How to create index mysql
SQL