The query builder also provides a variety of aggregate methods such as count, max, min, and sum. You may call any of these methods after constructing your query:
var getResults = query.from('users')
.count();
writeDump(getResults);
var getResults = query.from('users')
.max('age');
writeDump(getResults);
var getResults = query.from('users')
.min('age');
writeDump(getResults);
Of course, you may combine these methods with other clauses:
var getResults = query.from('users')
.where('active', '=', 1)
.max('age');
writeDump(getResults);