Pretty simple, declare an alias in your query and use it in the ORDER BY, i.e.:
SELECT
DB_ESTABLISHMENT_NAME,
AVG(DB_GRADE) AS AVGGRADE
FROM
ESTABLISHMENTS ES LEFT OUTER JOIN GRADES GR ON
ES.DB_ESTABLISHMENT_ID=GR.DB_ESTABLISHMENT_ID
GROUP BY
ES.DB_ESTABLISHMENT_ID
HAVING
AVG(DB_GRADE) > 2
ORDER BY
AVGGRADE
Hope that helps!
---- Message from Julien Martin <[EMAIL PROTECTED]> at 2004-05-05 19:41:32 ------
Hello,
Thanks a lot for the replies. I have changed the 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
GROUP BY
ES.DB_ESTABLISHMENT_ID
HAVING
AVG(DB_GRADE) > 2
ORDER BY
AVG(GRADE)
**************************
Now I am having a problem with the order by clause. How can I have the AVG
function in the ORDER BY clause or how can I sort by average grade?
Thanks in advance,
Julien Martin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Best regards,
Carsten R. Dreesbach mailto:[EMAIL PROTECTED]
Senior Consultant
Systar, Inc.
8000 Westpark Dr
Suite 450
McLean, VA 22102
USA
Tel: (703) 556-8436
Fax: (703) 556-8430
Cel: (571) 213-7904
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
