MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Return 8 romances that were made before 1999.
A
SELECT * FROM movies WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;
B
SELECT * FROM movies WHERE genre = romance AND year > 1999 LIMIT 8;
C
SELECT * FROM games WHERE genre = ‘romance’ AND year < 1999 LIMIT 8;
D
SELECT * FROM Movies WHERE genre = ‘romance’ AND year > 1999 LIMIT 8;
Explanation: 
There is 1 question to complete.