On 10/9/2016 9:01 AM, Roelof Wobben wrote:
I have this sql script to display the top25 fiims based on the average score of a flim.
I don't see where score figures in your query. You order films by the number of genres each is associated with. Is that what you meant?
Now I wonder if it's possible to also display the average score of a film.
Have you tried the obvious? SELECT films.*, AVG(films_genres.score) ... -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
