Re: [sqlite] display also the average score of a flim

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

[sqlite] display also the average score of a flim

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