What should I write the where clause?

SELECT * FROM books WHERE genre ="Science Fiction" ORDER BY first_published ASC LIMIT 1;

You place the WHERE clause after the FROM part like:

SELECT * FROM books WHERE condition ORDER BY first_published limit 5;

2 bummers I got as below, when I got 10 returns, the bummer was retrieving 'Science Fiction'. When I added genre = 'Science Fiction', I got 10 books were expected. The inquiry was order by title and limit 10 offset 2. Thanks

select * from books order by title limit 10 offset 2;

id title author genre first_published 20 Animal Farm George Orwell 1945 13 Armada Ernest Cline Science Fiction 2015 19 Contact Carl Sagan Science Fiction 1985 17 Dune Frank Herbert Science Fiction 1965 15 Emma Jane Austen Classic 1815 10 Frankenstein Mary Shelley Horror 1818 2 Harry Potter and the Chamber of Secrets J.K. Rowling Fantasy 1998 7 Harry Potter and the Deathly Hallows J.K. Rowling Fantasy 2007 4 Harry Potter and the Goblet of Fire J.K. Rowling Fantasy 2000 6 Harry Potter and the Half-Blood Prince J.K. Rowling Fantasy 2005 Bummer! Your query needs to retrive the earliest 'Science Fiction' book from the books table.

select * from books where genre = 'Science Fiction' order by title limit 10 offset 2;

id title author genre first_published 17 Dune Frank Herbert Science Fiction 1965 12 Ready Player One Ernest Cline Science Fiction 2011 18 The Circle Dave Eggers Science Fiction 2013 11 The Martian Andy Weir Science Fiction 2014 Bummer! Ten books were expected. 4 were returned in the results.

Could you link the challenge for me , i'll try it out myself.

here you go! thanks a lot!

https://teamtreehouse.com/library/reporting-with-sql/ordering-limiting-and-paging-results/paging-through-results-2

I tried the challenge myself

the answer to question:

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.

Answer:

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

Task 2: Imagine you're developing a Contacts application on a phone. You have a database with a phone_book table. It has the columns, first_name, last_name and phone. The phone has a technical limitation to show 20 contacts on a screen at a time. Write the SQL query to retrieve the 3rd page of results from the phone_book table. Contacts are ordered by last name and then first name.

Answer:

SELECT * FROM phone_book
ORDER BY last_name, first_name
ASC LIMIT 20 OFFSET 40;

Hope this helps

I'd think your query would look like:

SELECT * FROM books
WHERE books.genre = 'Science Fiction'
ORDER BY first_published 
ASC limit 10;

please tell if it is working or not,