Laravel: filter and group based on created_at and sum costs

Question

Based on the table below

I want to get all the records on the created_at column grouped by month and sum the cost month for each record.

Hope I can explain it.

Answer 1

You can do this

$monthlyCosts = DB::table('my_table')
            ->selectRaw("DATE_FORMAT(created_at, '%m-%Y') as month, SUM(cost) as total_cost")
            ->groupBy('month')
            ->get();