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

PHP

Posted by shawn khah
shawn khah
15,082 Points

need help pls

Challenge Task 1 of 2

Note: We will be writing ONLY the SQL query for this challenge. In a library database there's a books table. There's a title, author, genre and first_published column. The library database is connected to a website displaying 10 books at a time, sorted by the title alphabetically. Write a query to bring back the second page of results. Type in your command below. Get Help Check Work

SELECT*FROM books ORDER BY first_published DESC LIMIT 10 OFFSET 20

1 Answer

Joel Bardsley
Joel Bardsley
31,249 Points
Joel Bardsley
Joel Bardsley
31,249 Points

Note that the question is asking you to retrieve the second page of books, which there are 10 to a page. With your OFFSET of 20 you're effectively showing the third page of books.

Also, you need to order the results alphabetically by the book's title - your current code is ordering them by the first_published date.

If changing those values still results in a failed answer, double check the spacing you're using in your SELECT statement - sometimes the questions are quite picky about things like that.