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
Back
Docs
Schema
movielens
openflights
ecommerce
Run
Cancel
Name
Description
Loading...