Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems 23rd European Conference Adbis 2019 Bled Slovenia September 8 11 2019 Proceedings Lncs 11695

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Aida Kamisalic Latific

1st Edition

3030287297, 978-3030287290

More Books

Students also viewed these Databases questions

Question

4. Are there any disadvantages?

Answered: 1 week ago

Question

3. What are the main benefits of using more information technology?

Answered: 1 week ago

Question

start to review and develop your employability skills

Answered: 1 week ago