Re: Use of AVG in where clause

Julien Martin <[EMAIL PROTECTED]> wrote: >I have a sql query as follows: > >** >SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > >FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON >ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID > >WHERE > AV

Re: Use of AVG in where clause

I believe you have to add your AVG() to your GROUP BY clause. > I have a sql query as follows: > > ** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON > ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_I

RE: Use of AVG in where clause

bject: Use of AVG in where clause Hello, I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE AVG(

Re: Use of AVG in where clause

On Wed, 5 May 2004 19:12:00 +0200 Julien Martin <[EMAIL PROTECTED]> wrote: > Hello, > > I have a sql query as follows: > > ** > SELECT > DB_ESTABLISHMENT_NAME, > AVG(DB_GRADE) > > FROM > ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON > ES.DB_

Re: Use of AVG in where clause

At 19:12 +0200 5/5/04, Julien Martin wrote: Hello, I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE AVG(DB_G

Use of AVG in where clause

Hello, I have a sql query as follows: ** SELECT DB_ESTABLISHMENT_NAME, AVG(DB_GRADE) FROM ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID WHERE AVG(DB_GRADE) > 2 GROUP BY ES.DB_