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

Databases

Alex Forseth
Alex Forseth
8,017 Points
Posted by Alex Forseth
Alex Forseth
8,017 Points

What am I doing wrong?

Challenge Task 1 of 2 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.

It keeps on asking me why the code below doesnt have a SELECT query? What am i doing wrong?

SELECT * FROM books WHERE genre = "Fantasy" ORDER BY first_published ASC LIMIT 5;

1 Answer

Justin Iezzi
Justin Iezzi
18,199 Points
Justin Iezzi
Justin Iezzi
18,199 Points

I copy and pasted your answer into the the challenge and it worked fine for me. Make sure there isn't a space before SELECT, if that isn't it, I'd say maybe close out your browser and try it again.