Databases Reporting with SQL Ordering, Limiting and Paging Results Limiting Results

Loy Yee Ko
Loy Yee Ko
5,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

1 Answer

Chris Shearon
PRO
Chris Shearon
Pro 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;