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

Prices::where('product_id', $product->id)->get()->latest('id');

// Retrieve a model by its primary key...
$flight = App\Models\Flight::find(1);
// Retrieve the first model matching the query constraints...
$flight = App\Models\Flight::where('active', 1)->first();
// Shorthand for retrieving the first model matching the query constraints...
$flight = App\Models\Flight::firstWhere('active', 1);

//select specified colomns from all users
Employee::get(['name','email','title']);