Answers for "laravel join tables and get count of left fields and sum of the right fields"

SQL
0

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();
Posted by: Guest on September-24-2020

Code answers related to "laravel join tables and get count of left fields and sum of the right fields"

Code answers related to "SQL"

Browse Popular Code Answers by Language