selectSum in laravel code example
Example: select sum in laravel
Sometime for such queries you need to disable the strict check
So inside config/database.php and inside mysql,
Set 'strict' => false,
->select('user_id', DB::raw('SUM(points) as total_points'))