MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following code is written correctly?
A
SELECT * FROM movies WHERE imdb ____ rating is 1 AND ORDER by desc;
B
SELECT * FROM movies WHERE genre = ‘comedy’ AND ORDER BY ASC LIMIT 1:
C
SELECT * FROM movies WHERE genre = ‘horror’;
D
SELECT * FROM movies genre is horror, and rating is 2;
Explanation: 
There is 1 question to complete.