Wrong output in Learn SQL - Queries chapter


#1

I have noticed that the output for the below command isn’t correct.

SELECT * FROM movies
WHERE genre = 'comedy’
OR year < 1980;

This should give me the output of movies that either have a genre of comedy or were released before 1980. But it gives some results that aren’t comedy and many movies list from year 2000 and above. Some one from the learning department please check this part and verify if everything is working fine.


#2

then maybe those are year < 1980

maybe those are genre = 'comedy'


#3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.