AP
разные запросы
$week_now = DB::table('solds')
->select(DB::raw("count(count) as count, DATE_FORMAT(sell_date,'%d') as day"))
->where('created_at', '>=', DB::raw('DATE_SUB((SELECT MAX(created_at) FROM solds), INTERVAL 1 WEEK)'))
->groupBy(DB::raw('DAY(sell_date)'))
->orderBy(DB::raw("sell_date", "desc"))
->get();
