Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Anjali Rana
Courses Plus Student 842 PointsWe're using the library database again. There's a books table. There's a title, author, genre and first_published column
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.
2 Answers
Anjali Rana
Courses Plus Student 842 PointsSELECT * FROM books WHERE genre like "%Fantacy" ORDER BY first_published ASC LIMIT 5
Steven Parker
231,128 PointsIt looks like you have a typo.
You wrote "Fantacy" (with a "c") but the challenge is looking for "Fantasy" (with an "s").
And while it will likely work as is, you probably don't need to use LIKE here with a wildcard. Just a simple equality comparison would do.
For future questions, remember to post your code and a link to the course page.
Steven Parker
231,128 PointsSteven Parker
231,128 PointsHave you written any code yet?
At least please give it a good-faith attempt and then ask for help if you have trouble, and be sure to show your code and provide a link to the course page you are working with.