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 Unsubscribed User
Unsubscribed User
4,094 Points

Write a query to obtain the first 5 books in the Fantasy genre ordered by the year released. Oldest first. Select all co

We're using the library database again. There's a books table. There's a title, author, genre and first_published column.

Umesh Ravji
Umesh Ravji
42,386 Points
Umesh Ravji
Umesh Ravji
42,386 Points

Hi there, do you have any SQL that you have written for the problem?

Yousif Sayer
Yousif Sayer
7,073 Points

I guess you need to use LIMIT, for example SELECT * FROM books LIMIT(5); I hope this solve your issue.

2 Answers

Daniel Stopka
Daniel Stopka
13,520 Points
Daniel Stopka
Daniel Stopka
13,520 Points

Hi,

you need to run query based on these conditions:

  • WHERE genre is (=) Fantasy
  • results are ORDERED BY year released (I guess that it is in first_published column)
  • and then LIMIT them to 5... so only first 5 books from query will be displayed...

So query could look like this:

SELECT * FROM books WHERE genre = 'Fantasy' ORDER BY first_published ASC LIMIT 5;

Tawanda Kaseke
Tawanda Kaseke
11,202 Points
Tawanda Kaseke
Tawanda Kaseke
11,202 Points

SELECT * FROM books WHERE genre ='Fantasy' ORDER BY first_published SAC LIMIT 5;