In a library database there's a books table. There's a title, author, genre and first_published column.

Question

Hey, everyone, I need a help with a code challenge. Here it is:

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.

So I tried many things out and always got the same error. Here is the final query I got to, and I cannot think of anything else.

SELECT title, author, genre, first_published 
FROM books 
ORDER BY 
REPLACE( 
     REPLACE( 
          REPLACE(title, 'The ', ''), 
     'An ', ''),
 'A ', '' )
 LIMIT 10 OFFSET 10;

From what I understood, I need to get the specific four columns, since there are other columns in this table, then I need to order by title, and then get the second page of results. I really thought this final query could bring that result, but every time I try it, I get this error: Bummer! Your query needs to retrive the earliest 'Science Fiction' book from the books table.

I checked the table and saw that the earliest Science Fiction is Dune, and if we order by the title alphabetically, it should be in the 7th place, so it shouldn't be in the second page at all. Can anyone help me out with that? What am I seeing wrongly?

Thanks.

Answer 1 · 2016-06-29T08:19:21Z

June 29, 2016 8:19am

try

Select * from books order by title limit 10 offset 10

I think the science fiction message is a mistake. I've complained about it to treehouse about a month back. You might care to email them. Challenge messages are generally good, but there are a couple points in the SQL courses, where the messages you get back are misleading.

Answer 2 · 2017-10-25T23:14:18Z

October 25, 2017 11:14pm

Select * from books order by title limit 10 offset 10

Answer 3 · 2016-06-29T06:28:53Z

June 29, 2016 6:28am

I thought the code challenge was already linked, here is the link, Ashu Singh :

https://teamtreehouse.com/library/integrating-php-with-databases/limiting-records-in-sql/limit-and-offset

Answer 4 · 2017-11-21T14:47:41Z

November 21, 2017 2:47pm

SELECT * FROM books ORDER BY title ASC LIMIT 10 OFFSET 10;

Welcome to the Treehouse Community

Looking to learn something new?

Filipe Pacheco

Filipe Pacheco

In a library database there's a books table. There's a title, author, genre and first_published column.

Ashu Singh

Ashu Singh

4 Answers

Simon Coates

Simon Coates

Filipe Pacheco

Filipe Pacheco

HIDAYATULLAH ARGHANDABI

HIDAYATULLAH ARGHANDABI

Filipe Pacheco

Filipe Pacheco

tree house

tree house