Task 4


#1

Hi, I'm stuck on task 4.
There are no error messages, however it does not return any drama movies to the screen.

Code: SELECT * FROM MOVIES WHERE GENRE = 'ROMANCE';


Replace this line with your code.


#2

From what I can see you are not asking for drama movies, only romance.

If you want drama I think you need to use something like this…
SELECT * FROM MOVIES WHERE GENRE = 'DRAMA';

Otherwise this should return all genres…
SELECT * FROM MOVIES *;


#3

This is what code i used for task 4.
Compare to see where you went wrong.
--SELECT * FROM movies WHERE name LIKE '%bride%';