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!

question from:https://stackoverflow.com/questions/65845647/laravel-eloquent-array-foreach

Answer 1

Try this, replace the Model with your eloquent model name

Model::select(
'subject_id',
 IlluminateSupportFacadesDB::raw("COUNT(is_correct) as count")
)
->groupBy('subject_id')
->get();