Group By Aggregate in lambdaj

[Angkar]

Hi

I have a table containing employee and hours worked.  I want to generate a table that groups the data by employee id and weekending date, and sum's their hours worked.

empid    hours/day

4311             7.0

4311             7.0

9973              6.5

9973              8.0

4311              8.5

4311              8.0

 

I want to generate this list: (avg)

4311          7.625

9973         7.25

Appreciate your help with this. Thanks