Movies and ratings with correlated queries
Report a list of movies that received the most attention on the movie platform, (i.e. report all movies with more than 5 ratings and all movies with an average rating higher than 8).
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT *
FROM ___
WHERE ___ -- Select all movies with more than 5 ratings
(SELECT ___
FROM ___
WHERE ___);