Laravel Eloquent Array foreach

Question

Hey guys Im new to laravel. I have this table

How will i able to fetch count of 'is_correct' column for each subject?

Thanks guys!

Answer 1

Try this, replace the Model with your eloquent model name

Model::select(
'subject_id',
 Illuminate\Support\Facades\DB::raw("COUNT(is_correct) as count")
)
->groupBy('subject_id')
->get();