use Illuminate\Support\Facades\DB; $first = DB::table('users') ->whereNull('first_name'); $users = DB::table('users') ->whereNull('last_name') ->union($first) ->get();

$latestPosts = DB::table('posts') ->select('user_id', DB::raw('MAX(created_at) as last_post_created_at')) ->where('is_published', true) ->groupBy('user_id'); $users = DB::table('users') ->joinSub($latestPosts, 'latest_posts', function(JoinClause$join) { $join->on('users.id', '=', 'latest_posts.user_id'); })->get();

$users = DB::table('users') ->leftJoin('posts', 'users.id', '=', 'posts.user_id') ->get(); $users = DB::table('users') ->rightJoin('posts', 'users.id', '=', 'posts.user_id') ->get();

use Illuminate\Support\Facades\DB; $users = DB::table('users') ->join('contacts', 'users.id', '=', 'contacts.user_id') ->join('orders', 'users.id', '=', 'orders.user_id') ->select('users.*', 'contacts.phone', 'orders.price') ->get();

A. Average Value $price = DB::table('orders') ->where('finalized', 1) ->avg('price'); A. Sum Value $price = DB::table('orders') ->where('finalized', 1) ->sum('price');

if (DB::table('orders')->where('finalized', 1)->exists()) { // ... } if (DB::table('orders')->where('finalized', 1)->doesntExist()) { // ... }

A. view.blade.php <h3>Edit Bags</h3><br/> <?php $data = DB::table('bags')->where('id', $id)->get(); foreach($data as $d){ $title = $d->title; $address = $d->address; } ?> <div class="container"> <div class="card" style="padding:10px; background:white"> @if (session('message')) <div class="alert…