Re: [SQL] Calculating with sql

2002-06-27 Thread Masaru Sugawara
On Wed, 26 Jun 2002 22:18:07 +0200 Dennis Kaarsemaker <[EMAIL PROTECTED]> wrote: > From a copy of the CDDB-database i want to select the artist & album that > has on average the longest tracks. > > But in the tracks table there is no such field as length, so i have to > calculate it. But when i

[SQL] Calculating with sql

2002-06-27 Thread Dennis Kaarsemaker
I'm having trouble figuring out how to select something. This is the problem: >From a copy of the CDDB-database i want to select the artist & album that has on average the longest tracks. But in the tracks table there is no such field as length, so i have to calculate it. But when i try to do so