// Get the sum of all pages of books that have pages count greater than 170 Route::get('book_get_books_sum_price', function () { $countTotal = \App\Book::where('pages_count', '>', 170)->sum('pages_count'); return $countTotal; }); /** * Utility Methods - Eager Loading Techniques. more gonna be added */ // Skip nothing and take 3 records Route::get('book_skip_and_take', function () { $books = \App\Book::skip(0)->take(2)->get(); return $books; }); // Skip the first two records and take the next 3 records Route::get('book_skip_and_take_again', function () { $books = \App\Book::skip(2)->take(3)->get(); return $books; }); // Order the books in ascending order according to their title, `desc` is also an alternative Route::get('book_orderBy', function () { $books = \App\Book::orderBy('title', 'asc')->get(); return $books; }); // 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();