Subject Re: [firebird-support] Re: i want to this ; select avg(datefield) from ... but what?
Author Anderson Farias
Hi,

> Well let's say you have a real estate DB with a table describing when
> each hous has been repainted. You could select the last repaint from
> each house, group them by are, street or something, and then take the
> average of the date. That would indicate which area is in most need of a
> new repaint.

Thanks for your example.
Well, it probably makes sence then, although I must admit *I* did not get it

I'll take some more coffee
;-)

Regards,
Anderson Farias