Average Rating, like Netflix

[Brian Dunning]

Pretend I'm Netflix and I want to return a list of found movies,  
including the average of related ratings for each movie. Something  
like this:

select movies.*, average(ratings.rating) from movies, ratings where  
movies.movie_id=ratings.movie_id

I'm sure that's wrong in about 10 different ways but hopefully you get  
what I'm trying to do. Thanks.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org