Input SQL

SELECT m.title, AVG(r.rating) AS avg_rating, COUNT(r.id) AS review_count FROM movies m JOIN reviews r ON r.movie_id = m.id WHERE m.release_year > 2015 GROUP BY m.id HAVING AVG(r.rating) >= 4 ORDER BY avg_rating DESC LIMIT 10;

Formatted SQL Save Copy