Level 73
The easiest would be to use concat, and count.
SELECT CONCAT(YEAR(created_at), "-",MONTH(created_at), "-", WEEK(created_at)) AS WEEK, count(id)
FROM orders
GROUP BY 1;
1 like
Dec 12, 2022
4
Level 3
Group by Week
How can I group by week the orders in the last month with the date displayed being the start of the week? For example I want to have
2022-12-1 : 5
2022-12-7 : 10
2022-12-14 : 13
2022-12-21 : 34
2022-12-28 : 89
Level 3
@Tray2 how would this look in query builder?
Level 2
$orders = Order::where('created_at', '>=', Carbon::now()->subMonth())
->get()
->groupBy(function($order) {
return Carbon::parse($order->created_at)->startOfWeek();
});
Level 102
Use this to convert it: https://chat.openai.com/chat
And just let the query builder do it :) Hint. Its a selectRaw with a groupBy
Please or to participate in this conversation.