Convert MySQL query in Eloquent query.

I think this should work:

$result = \DB::table('histories')
 ->selectRaw('number, DATE(start), sum(duration), count(*), SUM(if(duration = 0, 1, 0)) AS comments')
 ->groupBy(\DB::raw('number, DATE(start)'));

dd($result);

There's also really no benefit to using eloquent in that particular situation. As you see, it's almost entirely raw statements anyway. It would actually be faster to just use your original query as then php/laravel doesn't have to translate the eloquent query back to raw sql.

$query = 'select number,DATE(start),sum(duration),count(*),SUM(if(duration = 0, 1, 0)) AS comments from histories group by number,DATE(start)';

$result = \DB::unprepared($query);