Re: Complex SQL

Hi Jim,

This script

CREATE TABLE TEST(D DATE, N NUMBER(5));

INSERT INTO TEST(D, N)VALUES('02-JAN-02', 10);
INSERT INTO TEST(D, N)VALUES('03-JAN-02', 17);
INSERT INTO TEST(D, N)VALUES('04-JAN-02', 83);

SELECT T1.D, SUM(T2.N)/COUNT(T2.N)
FROM TEST T1, TEST T2
WHERE T2.D <= T1.D
GROUP BY T1.D; DROP TABLE TEST; retieves

D SUM(T2.N)/COUNT(T2.N)

--------- ---------------------
02-JAN-02                    10
03-JAN-02                  13.5
04-JAN-02            36.6666667