// Fetching all records with the where clause in conjunction with a column Name a.k.a magic Where
Route::get('book_get_whereColumnName', function () {
    $results = \App\Book::whereTitle('My Fourth Book!')->get();
    return $results;
});
// Return all books that dont exist. .ie books that have the title column as NULL
Route::get('book_get_whereNull', function () {
    $results = \App\Book::whereNull('title')->get();
    return $results;
});
/**
 * AGGREGATES
 */
// Get the number of books in the database
Route::get('book_get_books_count', function () {
    $booksCount = \App\Book::count();
    return $booksCount;
});
// Get the number of books that have page count greater than 140
Route::get('book_get_bookPages_count', function () {
    $booksCount = \App\Book::where('pages_count', '>', 140)->count();
    return $booksCount;
});
// Get the minimum number of pages i.e books with pages above 120, at least ..but the minimum this
// will return 122
Route::get('book_get_books_min_pages_count', function () {
    $minPagesCount = \App\Book::where('pages_count', '>', 120)->min('pages_count');
    return $minPagesCount;
});
// Get the maximum number of pages i.e  books with pages above 120, return the highest number of pages
// this will return 200