Caleb Newell5,077 Points
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. Please retrieve all columns of information.
Steven Parker195,592 Points
The ORDER BY clause is what you would use to meet the requirement in the instructions to display the books "sorted by the title alphabetically".
If you need a refresher, it was covered in the Retrieving Results in a Particular Order video.
Also, if this is to be the second page of results, the OFFSET should be the same as the LIMIT.
Jonathan GrieveTreehouse Moderator 85,481 Points
ORDER BY is how you get your alphabetical listing of results.
You need to choose the correct column to order the data by. Also be aware that SQL is quite picky sometimes about where a keyword should go in a statement. Also, what are the values you put into the LIMIT and OFFSET keywords? Where does the cutoff happen and do they return 10 results as required?
Good luck with it. Keep trying and all this will stick eventually. :)