Welcome to the Treehouse Community
Looking to learn something new?
Matthew Nel57 Points
Not sure what I'm doing wrong here. Should the WHERE <condition> = something? Like genre=fantasy? Cheers
We're using the library database again. There's a books table. There's a title, author, genre and first_published column. Write a query to obtain the first 5 books in the Fantasy genre ordered by the year released. Oldest first. Select all columns.
Steven Parker215,958 Points
I think you have the right idea.
You didn't provide a link to the challenge, but from the instructions you quoted, it looks like you're exactly right, except that you probably need quotes around the genre value. So your query would likely start with:
SELECT * FROM books WHERE genre = "Fantasy" ...
Of course, you still need to add the parts that handle the ordering and limit the output to the first 5.
If you need help with any future issues, be sure to include a link to the challenge (usually automatic when you use the "Get Help" button) and also your complete answer up to that point.
SELECT * FROM books WHERE genre = "Fantasy" ORDER BY first_published ASC LIMIT 5;