I can’t for the life of me figure out what i’m messing up on here. on 9/23, writing queries.
Return 10 movies with an IMDb rating greater than 6, are comedies, were made after 1995, and sorted by IMDb rating from highest to lowest.
(Hint: you can use AND more than once in a statement)
So I write my code as:
SELECT * FROM movies
WHERE genre = comedy
and imdb_rating > 6
AND year > 1995
ORDER BY imdb_rating DESC
but it just sits there and spins…
i’ve got the semicolon, as far as my knowledge goes, my syntax is right.
any idea why it’s not working?