Show SUM aggregate per month

[dnextreme88]

Hi, I'm trying to get the sum of prices per month on a given period. The query for getting the SUM on a given month is similar to:

select SUM(price) from sold_items where month(date_sold) = '01';

How could I do this using this package? I can get the yearly prices just fine

[majdghithan]

$data = Trend::model(SoldItem::class)
->dateColumn('date_sold')
->between(
start: now()->startOfYear(),
end: now()->endOfYear(),
)
->perMonth()
->sum('price');