laravel order by

1$posts = Post::orderBy('id', 'DESC')->get();

1->orderBy('id', 'DESC');

1$users = DB::table('users')
2         -> orderBy('name', 'desc')
3         -> get();

1$affected = DB::table('users')
2              ->where('id', 1)
3              ->update(['votes' => 1]);

1/**
2 * Show the application dashboard.
3 *
4 * @return \Illuminate\Http\Response
5 */
6public function index()
7{
8    $messages = Message::select("*")
9                            ->where('receiver_id',$id)
10                            ->orderBy('created_at', 'desc')
11                            ->get();
12  
13    dd($messages);
14}

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