$orders = DB::table('orders') ->selectRaw('price * ? as price_with_tax', [1.0825]) ->get();
$orders = DB::table('orders') ->whereRaw('price > IF(state = "TX", ?, 100)', [200]) ->get();
$orders = DB::table('orders') ->select('department', DB::raw('SUM(price) as total_sales')) ->groupBy('department') ->havingRaw('SUM(price) > ?', [2500]) ->get();
$orders = DB::table('orders') ->orderByRaw('updated_at - created_at DESC') ->get();
Clickable & Draggable!