Laravel fetch data in details

where clause:

$users = DB::table('users')
->where('votes', '=', 100)
->where('age', '>', 35)
->get();

$users = DB::table('users')
->where('name', 'like', 'T%')
->get();

$users = DB::table('users')->where([
  ['status', '=', '1'],
  ['subscribed', '<>', '1'],
])->get();

$users = DB::table('users')
  ->select('name', 'email as user_email')
  ->get();

orWhere and whereNot:

$users = DB::table('users')
->where('votes', '>', 100)
->orWhere('name', 'John')
->get();

$users = DB::table('users') 
->whereNot('votes', '>', 100) 
->orWhere('name', 'John') 
->get();

whereBetween & whereNotBetween:

$users = DB::table('users')
->whereBetween('votes', [1, 100])
->get();

$users = DB::table('users')
->whereNotBetween('votes', [1, 100])
->get();

whereIn / whereNotIn / orWhereIn / orWhereNotIn:

$users = DB::table('users')
->whereIn('id', [1, 2, 3])
->get();

$users = DB::table('users')
->whereNotIn('id', [1, 2, 3])
->get();

$users = DB::table('users')
->orWhereIn('id', [1, 2, 3])
->get();

$users = DB::table('users')
->orWhereNotIn('id', [1, 2, 3])
->get();

whereDate / whereMonth / whereDay / whereYear / whereTime

$users = DB::table('users')
->whereDate('created_at', '2016-12-31')
->get();

$users = DB::table('users')
->whereMonth('created_at', '12')
->get();

$users = DB::table('users')
->whereDay('created_at', '31')
->get();

$users = DB::table('users')
->whereYear('created_at', '2016')
->get();

$users = DB::table('users')
->whereTime('created_at', '=', '11:20:45')
->get();

whereColumn / orWhereColumn

$users = DB::table('users')
->whereColumn('first_name', 'last_name')
->get();

$users = DB::table('users')
->whereColumn([
  ['first_name', '=', 'last_name'],
  ['updated_at', '>', 'created_at'],
])->get();

join:

$users = DB::table('users')
   ->join('contacts', 'users.id', '=', 'contacts.user_id')
   ->join('orders', 'users.id', '=', 'orders.user_id')
   ->select('users.*', 'contacts.phone', 'orders.price')
   ->get();