Help with Problem 9 in SQL: Queries


9 - 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)

When I input my code, the update box will not give me my table so something is wrong...

SELECT * FROM movies
WHERE imdb_rating < '6'
AND genre = 'comedy'
AND year < 1995
ORDER BY imdb_rating DESC


made after 1995 would be > 1995

+++ show all table defintions
select * from sqlite_master;

++++ANALYZE in sqlite


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