COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Write a code for the following:Return all romances that have an imdb ____ rating over 6.
|
|
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb ____ rating > 6;
|
|
|
SELECT * FROM movies WHERE genre = ‘romance’ AND imdb ____ rating < 6;
|
|
|
SELECT imdb ____ rating, name FROM movie WHERE genre = ‘romance’ AND imdb ____ rating > 6;
|
|
|
SELECT * FROM movies WHERE genre = romance and imdb ____ rating < 6;
|
Explanation:
There is 1 question to complete.