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

Posted by adriano ferreira
adriano ferreira
1,936 Points

limiting

Hi,

On the challenge task 1 it asks to Write a query to obtain the first 5 books in the Fantasy genre ordered by the year released. Oldest first. Select all columns.

SELECT * FROM books WHERE genre ORDER BY date DESC LIMIT 5;

I have tried various options but I don't know what I am missing.

Thanks, Adriano

1 Answer

Ari Misha
Ari Misha
19,323 Points
Ari Misha
Ari Misha
19,323 Points

Hiya Adriano! Remove the "WHERE" clause and you're good to go 'coz you dont need "WHERE" clause and its not doing anything in your query , which makes it in incomplete code. I hope it helped. (: