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

genre = "Science Fiction"

Why is it saying there is something wrong with the SQL: select * from books where genre = "Science Fiction" order by genre asc limit 1;

1 Answer

Steven Parker
Steven Parker
194,932 Points

The instructions say to "Find the earliest Science Fiction book in our library." You can assume "earliest" refers to the publication date.

So the WHERE clause is fine, but you'll need to ORDER BY a different column than genre.

Thank you so much Steven!