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