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