SQL Functions

AVG - return average value

Select.from(db, AVG.of(tabUser.colAge())).where(tabUser.colLastName(),"Nowak").result();

COUNT

Select.from(db, COUNT.of(tabUser.colAge())).where(tabUser.colAge(),GT,50).result();

MAX - return max value

Select.from(db, MAX.of(tabUser.colAge()).result();

MIN - return min value

Select.from(db, MIN.of(tabUser.colAge()).result();

SUM - retun sum of values

Select.from(db, SUM.of(tabUser.colAge()).where(tabUser.colLastName(),"Nowak").result();

Projections and functions

Select.from(db, tabUser.colPosition(),AVG.of(tabUser.colAge())).result();