COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Return 5 movies with an imdb rating of 7 or higher.
|
|
SELECT * FROM movies WHERE imdb ____ rating = 7 limit 5;
|
|
|
SELECT * FROM movies WHERE imdb-rating >= 7 LIMIT 5;
|
|
|
SELECT * FROM movies WHERE imdb ____ rating <= 7 LIMIT 5;
|
|
|
SELECT * FROM movies WHERE imdb ____ rating >= 7 LIMIT 5;
|
Explanation:
Detailed explanation-1: -So if you go to the Rental store, and see a movie that is relatively popular and has a rank of 7.5, then it is within the top 25% of movies. If you are very picky, use a threshold of 8.0: there are only 430 with higher than 8, or approximately 9% of the movies in the IMDB with at least 10k votes.
Detailed explanation-2: -1. The Shawshank Redemption (1994) Over the course of several years, two convicts form a friendship, seeking consolation and, eventually, redemption through basic compassion.
Detailed explanation-3: -Filmmaker-actor Rishab Shetty’s Kantara has become one of the highest-rated Indian films on IMDb with a rating of 9.5 out of 10.
There is 1 question to complete.