max and avg together

Hi!

I have a quite simple problem but I can't resolve this one.

I have a table with structure: date, code and amount. And want to compose a query which gives for result date, code and average maximum on each day.

For example source data is

01-01-2004 A 10.00
01-01-2004 A 30.00
02-01-2004 B 50.00
02-01-2004 C 40.00
03-01-2004 A 99.00

and result would be

01-01-2004 A 20.00
02-01-2004 B 50.00
03-01-2004 A 99.00

Thx for any help! Received on Wed Oct 06 2004 - 16:40:12 CDT