I have a table called ratings.
It has 3 rows of interest
id foreign key to another table
qual a quality rating
u the user who gave that rating
(also a foreign key into the users table)
Now I would like to select all the unique ids for which the average
quality is below 1.5
so if we have
id qual u
1 5 999
1 4 888
2 1 999
2 1 888
3 3 777
3 2 888
it would tell me that id 2 has average ratings below 1.5
it doesn't like SELECT id from ratings where AVG(qual) < 1.5 group by id
unfortch this server is still 3.23
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
