Hello,
I have this sql script to display the top25 fiims based on the average
score of a flim.
SELECT films.*
FROM films
JOIN films_genres on films_genres.genre_id in (#{all_genres.join(' , ')})
WHERE films.id = films_genres.film_id and films.id !=2 AND
count(films_genres.score) > 0
GROUP BY films.id
ORDER BY count(films_genres.film_id) DESC"
Now I wonder if it's possible to also display the average score of a film.
Regards,
Roelof
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users