Compute average SQL statement

From: Hendrik Lampert <henhouse_at_gmx.net>
Date: Wed, 7 Jan 2004 11:32:40 +0100
Message-ID: <btgn8k$809$1@online.de>

Hi,

i'm looking for a sql statement to compute an average from the following sample:

Week Value_a Avg.

---

1                10                 10 / 1= 10
2                 20                 (10+20) / 2 = 15
3                 5                 (10+20+5 ) / 3 = 11,66

....

The average Avg. should be computed out of Value_a for each week.

Thanks.

Hendrik Received on Wed Jan 07 2004 - 04:32:40 CST