Group identical records and return their count Laravel 5.3?

Question

Laravel

There are thousands of different records in the table, and it is growing. The structure is something like this:

Now we need to group all columns where the voted_for is the same, returning their number and the string in the voted_for column.
Approximately such a grouping result, 11 is the number of identical Half-Life keys: ['votes' => '11', 'for' => 'Half-Life'].

Answer 1

$allVotes = DB::table('votes')
                 ->select('voted_for', DB::raw('count(*) as total'))
                 ->groupBy('voted_for')
                 ->get();
    dd($allVotes);

Answer 2

SELECT COUNT(voted_for), voted_for FROM table GROUP BY voted_for;

But I think it could be better.
As a result, you can get two columns - voted_for and the number of duplicates in it.

Answer 3

$v = App\Model::where('voted_for', 'Half-Life')->get();
$v->count();
See secret link for more information.