SELECT title, COUNT(*) AS ratings_count, ROUND(AVG(rating), 2) AS avg_rating FROM movies INNER JOIN ratings ON ratings.movie_id = movies.id GROUP BY movies.id HAVING COUNT(*) >= 10 ORDER BY avg_rating DESC LIMIT 50
Run Cancel

Loading...