aggregate methods provided by query builder in Laravel code example

Example: DB::table('users')->get();

DB::table('users')->where('name', Input::get('name'))->get();