Loy Yee Ko5,814 Points
SELECT * FROM books WHERE genre ORDER BY first_published ASC LIMIT 5; fail to return any result
The quiz has asked to write a query to obtain top 5 books from fantasy genre from oldest to the latest, SELECT * FROM books WHERE genre ORDER BY first_published ASC LIMIT 5; is my answer and I am stuck
Chris ShearonPro Student 14,369 Points
Looks like you're missing a predicate in your WHERE clause. The genre the question is asking for is 'Fantasy'.
The query should look like this.
select * from books where genre = 'Fantasy' order by first_published asc limit 5;