}); // Group the books by the price...e.g if 3 books have thesame price, it groups them together as one Route::get('book_groupBy', function () { $books = \App\Book::groupBy('price')->get(); return $books; }); // Return all books that have pages_count less than 150 Route::get('book_having', function () { $books = \App\Book::having('pages_count', '<', 150)->get(); return $books; }); // Return all books including the ones that have been deleted // Listen: this requires your migration already has $table->softDeletes(); // and your Model also uses the Eloquent SoftDeletes trait Route::get('all_books_including_those_that_have_been_deleted', function () { $books = \App\Book::withTrashed()->get(); return $books; }); // Return only all the books that have been deleted Route::get('only_deleted_books', function () { $books = \App\Book::onlyTrashed()->get(); return $books; }); // Restore a record that has been deleted provided you have the id Route::get('restore_deleted_book', function () { $trashedBook = \App\Book::find($trashedBookId); $trashedBook->restore(); }); // Truly delete a record, I mean really really delete..I mean Bye Bye to the record Route::get('truly_delete_a_record', function () { // $bookId refers to the id of the book you want to truly delete