Question: Time Limit: 2 , Memory Limit: 2 5 6 0 0 0 You have a database with movies and ratings tables. You want to find

Time Limit: 2, Memory Limit: 256000
You have a database with "movies" and "ratings" tables. You want to find movies that have an average rating of at least 4.0 and have received at least 3 ratings.
'movies' Table:- movie_id INT PRIMARY KEY movie_name VARCHAR(255)
'ratings' Table:- rating_id INT PRIMARY KEY, movie_id INT, rating DECIMAL(3,1), FOREIGN KEY (movie_id) REFERENCES movies (movie_id)
Write an SQL query to retrieve the names of movies that meet the rating criteria. Return movie_name in ASC.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!