Calculating the average for a set of values

Hi,

Please could someone tell me how to calculate the average for a set of values in the database.

I tried out the simple statistics and aggregate functions. But did not yield any results.

Please do give in details about the mapping using the simple/aggregated function.

Reply a.s.a.p