/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 vote206 views1 answer
Count mysql server db tables
SQL
3 votes229 views3 answers
Mysql auto increment after delete
SQL
2 votes211 views1 answer
Oracle apex who is connected
SQL
2 votes197 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote184 views1 answer
Importance of comment in mysql
SQL
0 vote198 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote190 views1 answer
Sql server convert date to weekday
SQL
1 vote405 views1 answer
Foreign key in oracle sql developer
SQL
2 votes241 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote196 views1 answer
Docker export psql sql
SQL