join function query builder laravel code example

Example 1: laravel not in query

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Example 2: laravel 8 orderby

$flights = App\Models\Flight::where('active', 1)
               ->orderBy('name', 'desc')
               ->take(10)
               ->get();