COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Return 5 movies that have an imdb rating greater than 4 and are comedies.
|
|
SELECT * FROM movies WHERE imdb ____ rating > 4 AND genre = ‘comedy’ LIMIT 5;
|
|
|
SELECT ALL FROM movies WHERE imdb ____ rating < 4 AND genre = ‘comedy’ LIMIT 5;
|
|
|
SELECT * FROM movies WHERE imdb rating > 4 AND genre = comedy LIMIT 5;
|
|
|
SELECT ALL FROM movies WHERE imdb ____ rating > 4 AND genre = ‘comedy’;
|
Explanation:
There is 1 question to complete.